[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/