Update external links prompt upon opening

[Nate]

I see that Excel 2002 & later allow you to change the startup settings
for updating external links so that you will not be asked and the links
will not be updated automatically. Is there a way to do this in Excel
2000?

 

[Dave Peterson]

You could use another workbook that contains a macro to open your real
workbook. You can specify what you to do in that macro.

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=0
ThisWorkbook.Close savechanges:=False
End Sub