If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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... |
#2
|
|||
|
|||
Update link without prompt
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 :-) |
#3
|
|||
|
|||
Update link without prompt
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 :-) |
#4
|
|||
|
|||
Update link without prompt
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 :-) |
Thread Tools | |
Display Modes | |
|
|