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? |
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 |