Hi Heidi,
I have 2 links to excel in a word document. The Edit
LInks menu is set for automatic updating. Why when I open
the file in Word am I prompted to update the links??
It would be very helpful if you'd state the version of word
involved!
Because you've set them to auto-update
Check under
Tools/Options/General whether "Update links on open" is
activated. If it is, try turning it off. That will suppress
the message, but then the links probably won't update when
you open the document...
Microsoft has been forced to build in more and more warning
mechansisms due to "nasty people" exploiting their software's
strengths for criminal and destructive purposes. These
warnings are for your protection. There are ways to work
around them, but they have to be used consciously.
You can put an AutoOpen macro in the document that will
update links. A very simple one that does all fields, but
only in the main body of text:
Sub AutoOpen
ActiveDocument.Range.Fields.Update
End Sub
If you wanted to do only LINK fields, and in all parts of the
document, it would be a bit longer...
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
