Update external links prompt upon opening

  • Thread starter Thread starter Nate
  • Start date Start date
N

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?
 
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
 
Back
Top