Updating Excel Worksheets in Word

[Guest]

I have created a Word doc with a number of Excel worksheets. These
worksheets have links to external spreadsheets. Right now when I update the
source document, the speadsheets in the Word doc don't update until I
physically go into the worksheet. Is there a way to get the embedded Excel
sheets to update as soon as the Word doc is opened?

Thanks,
jim

 

[Doug Robbins - Word MVP]

Try Tools>Options>General and check the box for "Update automatic links at
Open"

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Guest]

I'm afraid that's not it (that was already checked).
jim

 

[Guest]

Hi Jim-

In the Word doc, take a look at Edit>Links... to make sure the links are set
to Automatic Update.

HTH |:>)