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

Try ToolsOptionsGeneral 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

"jimatthecimc" wrote in message
...
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

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

"Doug Robbins - Word MVP" wrote:

Try ToolsOptionsGeneral 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

"jimatthecimc" wrote in message
...
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

Hi Jim-

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

HTH |:)

"jimatthecimc" wrote:

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

"Doug Robbins - Word MVP" wrote:

Try ToolsOptionsGeneral 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

"jimatthecimc" wrote in message
...
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