Can someone help me what I think should be an easy task but is proving anything but 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 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 addrees 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. This is so frustrating, any clues anyone?
Hi Mac NorLog, It seems that, although the links will update immediately after they've been created, once the document has been saved & closed, they become static. So that approach isn't going to work. Sorry to have misled you on that. I guess a macro-based solution will be required. Your prospects of a solution might be best if you post your query simultaneously in microsoft.public.word.vba.general and microsoft.public.word.oleinterop. -- Cheers macropod [MVP - Microsoft Word] "Mac NorLog" wrote in message news:316E6A0B-170D-4C43-B6E1-9375CB2CB646@microsoft.com... > Can someone help me what I think should be an easy task but is proving > anything but 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 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 addrees 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. > This is so frustrating, any clues anyone? >
