Update Link Continue prompt

[Tasha]

I keep getting an Update Link prompt every time I open a file. The prompt
asks to Continue or Edit Links. If I go into Edit links, they are showing
status OK. I don't want this prompt. I have done Edit>Links>Startup Promp
and checked 'Don't display the alert and update links', saved and closed the
workbook. Upon opening, the link prompt is still coming up. I have told it
not to ask to update, and even tried putting
Application.AskToUpdateLinks=False in the open workbook code, and it is STILL
coming up. Can someone please tell me how to get this prompt to turn off?

 

[Dave Peterson]

There's a link that you (and excel) aren't finding.

I'd get Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

ps. When excel opens the file, it reacts to the links before it gets to your
code.

 

[Tasha]

Thanks for your reply Dave. I have that program, but it didn't show any
other links. I did find a solution though. I turned off all options for
updating links, and then added the code below to update through workbook open:

Private Sub Workbook_Open()
Dim vLinkSources
Dim iLinkSource As Integer
vLinkSources = ThisWorkbook.LinkSources(xlExcelLinks)
If Not IsEmpty(vLinkSources) Then
For iLinkSource = LBound(vLinkSources) To UBound(vLinkSources)
ThisWorkbook.UpdateLink vLinkSources(iLinkSource), xlExcelLinks
Next
End If
End Sub