Update Automatic Links at Open

[Steve Marsden]

In Word 2003 if the above option is set and you have a Word document with
an embedded Excel sheet in it, the sheet is updated in the Word document
automatically if you update the Excel sheet but when you originally open the
Word document, Word displays a message warning that this will happen which
you have to acknowledge with OK.

Is there any way to disable this message so that it just updates
automatically without prompting.

If you turn the above option off, the message doesn't appear but the linked
spreadsheet doesn't get updated automatically. You have to right click and
select Update Link.

We want to automatically update without the warning message when you open
the document. This used to happen in Word 2002.

 

[Cindy M -WordMVP-]

Hi Steve,

Is Tools/Options/General/Confirm conversions on open active? If it is, does it
make a difference if you turn it off?

In Word 2003 if the above option is set and you have a Word document with
an embedded Excel sheet in it, the sheet is updated in the Word document
automatically if you update the Excel sheet but when you originally open the
Word document, Word displays a message warning that this will happen which
you have to acknowledge with OK.

Is there any way to disable this message so that it just updates
automatically without prompting.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail