[Mac NorLog]

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?

[Robert M. Franz (RMF)]

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/