Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking excel tables in Word 2007
Can someone help me with what I think should be an easy task but is proving
anything in Word 2007. I use documents in word that contain excel tables to hold data that require formula. The results in the first table affect the data presented in the second table & so on. I assumed that a simple "Paste Link" would do the trick but although I can do the link when changing the data in the first table, the data in the second changes the first time but any subsequent changes are not registered & the second table remains unchanged. When I then go into the table to view the cell formula there is a reference to the first table but the cell address appears as RxCx & then displays an error ##REF in the cell. Having followed some of the discussions I have upgraded with all the current upgrades for Office, however, this only had the effect of causing my original file to become corrupt & cannot now be open. It appears that once the file is saved that the link becomes static & therefore doesn't change with the source data. It has been suggested that this can only be solved by use of macro's, an area I am not familiar with. Can anyone help? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking excel tables in Word 2007
Hello Mac
Mac NorLog wrote: Can someone help me with what I think should be an easy task but is proving anything in Word 2007. I use documents in word that contain excel tables to hold data that require formula. The results in the first table affect the data presented in the second table & so on. I assumed that a simple "Paste Link" would do the trick but although I can do the link when changing the data in the first table, the data in the second changes the first time but any subsequent changes are not registered & the second table remains unchanged. [..] I don't have any 2007 experience in this, but in previous versions, I've settled with "paste link" from one Excel file to various places in the document and doing any Excel-related changes in the source XLS file only. After updating the links in Word (CTRL-A, followed by F9), the data was updated. As long as I used Word only for presenting the linked material, and not for trying to update the Excel source, things seemed to work fine. 0.2ΒΆ Robert -- /"\ ASCII Ribbon Campaign | MSFT | \ / | MVP | Scientific Reports X Against HTML | for | with Word? / \ in e-mail & news | Word | http://www.masteringword.eu/ |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking excel tables in Word 2007 | Tables | |||
Linking Excel data into pre-existing Word tables | Tables | |||
Linking or embedding an Excel 2007 workbook in Word 2007 | Microsoft Word Help | |||
Linking Excel tables in Word? | Tables | |||
Linking Excel data to tables in Word | Tables |