Code that will automatically update links upon opening workbook

Obviously the code below doesn't work, but I find that setting the Startup prompt to "Don't display the alert and update links" doesn't work either. The workbook persists in displaying the prompt upon opening.

Thanks,
John
Private Sub Workbook_Open()
ThisWorkbook.UpdateLinks
End Sub

Open in new window

LVL 1
John CarneyReliability Business Tools Analyst IIAsked:
Who is Participating?
 
Ardhendu SarangiSr. Project ManagerCommented:
Hi John,

So, you need the excel to update the links silently without notifying the users, right?

Please see the following link  http://support.microsoft.com/kb/826921 which has steps on how to suppress the message and to automatically update the links when you open a workbook.

0
 
MeLindaJohnsonCommented:
Did you check to see if the box "Update links to other documents" is checked in Excel Options.
0
 
John CarneyReliability Business Tools Analyst IIAuthor Commented:
Had a bunch of stuff thrown at me today, I'll get back to this as soon as I can.

Thanks,
John
0
 
John CarneyReliability Business Tools Analyst IIAuthor Commented:
Thanks, pari123. Sorry I took so long to get back. Melinda, forgive me for not giving you any points but I'm still stuck with Excel 2003 here at work so I couldn't use the 2007 fix. But thanks for posting.

- John
0
 
Ardhendu SarangiSr. Project ManagerCommented:
Thanks for the points john!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.