Update link without prompt


J

Jim Orson

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...
 
Ad

Advertisements

C

Cindy M -WordMVP-

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 :)
 
J

Jim Orson

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...
 
Ad

Advertisements

C

Cindy M -WordMVP-

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top