<div>
Did you check to see if the box &quot;Update links to other documents&quot; is checked in Excel Options.<br />

</div>


Did you check to see if the box "Update links to other documents" is checked in Excel Options.


<div>
Had a bunch of stuff thrown at me today, I'll get back to this as soon as I can.<br />
<br />
Thanks,<br />
John
</div>


Had a bunch of stuff thrown at me today, I'll get back to this as soon as I can.

Thanks,
John

<div>
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.<br />
<br />
- John
</div>


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

<div>
Thanks for the points john! 
</div>


<div>
<div class="content wysiwyg-content">
Obviously the code below doesn't work, but I find that setting the Startup prompt to &quot;Don't display the alert and update links&quot; doesn't work either. The workbook persists in displaying the prompt upon opening.<br />
<br />
Thanks,<br />
John<br />

<pre><code id="code-8062303">Private Sub Workbook_Open()
ThisWorkbook.UpdateLinks
End Sub</code></pre>
</div>
</div>


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

Code that will automatically update links upon opening workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.