Updating Links

  • Thread starter Thread starter bsando
  • Start date Start date
B

bsando

I have a word doc that has a link to excel. I don't want to be aske
everytime if i want to update the link. I want the doco to update wit
out asking.

I looked at the options in the tool bar but could not find anything
anything obvious anyway
 
Do you have the "Update automatic links at open" box checked under
Tools>Options>General?

I am not sure of the behaviour, but if that is the case, then uncheck it and
use an AutoOpen macro in the document that contains the code

Dim alink As Field
For Each alink In ActiveDocument.Fields
If alink.Type = wdFieldLink Then
alink.Update
End If
Next alink



--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 
I too am having the same issue in 2003. We open the word doc through excel
(a hyperlink) and it prompts us if we want to update links. The option is
checked in word, so what is the next step?

Doug Robbins said:
Do you have the "Update automatic links at open" box checked under
Tools>Options>General?

I am not sure of the behaviour, but if that is the case, then uncheck it and
use an AutoOpen macro in the document that contains the code

Dim alink As Field
For Each alink In ActiveDocument.Fields
If alink.Type = wdFieldLink Then
alink.Update
End If
Next alink



--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
Click to expand...
 
Back
Top