Update external links prompt upon opening

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
Fri Feb 24 17:33:24 CST 2006

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

Nate wrote:
>
> 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