Update link without prompt

Greetings,

I have a Word document that contains a link to an Excel worksheet. I have
the option set to do an Automatic Update for the link. However, when I open
the document, I get a prompt asking if I want to update the link. How can I
stop the prompt and have the link simply update automatically without my
acknowledgment?

Thanks for any help!

Jim...

Hi Jim,

I have a Word document that contains a link to an Excel worksheet. I have
the option set to do an Automatic Update for the link. However, when I open
the document, I get a prompt asking if I want to update the link. How can I
stop the prompt and have the link simply update automatically without my
acknowledgment?

Which version of Word is this? Does the information in this article help at
all?

http://support.microsoft.com?kbid=330079
WD: How the Behavior of the Word Fields Changes After You Install the Word
Update

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

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

Cindy,

Thank you for your response. I am using Word 2003. Since the Knowledge
Base article only seems to cover up to Word XP, I decided not to try the
registry edit. I was able to come up with a different way of eliminating
the prompt though. What I did was place the following VBA code into the
ThisDocument section of the Project to fire when the file is opened:


Private Sub Document_Open()
Selection.WholeStory
Selection.Fields.Update
End Sub


Works great and does exactly what I wanted. BTW, the reason for selecting
everything is that there is more than one link that needs updating.

Thank you again for your response!

Jim...


"Cindy M -WordMVP-" wrote in message
news:VA.00009833.01a78478@speedy...
Hi Jim,

I have a Word document that contains a link to an Excel worksheet. I
have
the option set to do an Automatic Update for the link. However, when I
open
the document, I get a prompt asking if I want to update the link. How
can I
stop the prompt and have the link simply update automatically without my
acknowledgment?

Which version of Word is this? Does the information in this article help
at
all?

http://support.microsoft.com?kbid=330079
WD: How the Behavior of the Word Fields Changes After You Install the Word
Update

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

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

Hi Jim,

I am using Word 2003. Since the Knowledge
Base article only seems to cover up to Word XP, I decided not to try the
registry edit.

The same information applies, you just need to use a "11" where the
article says "10" in the Registry key :-)

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

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