Update links automatically

Hi,

This is probably simple but is there any way to
automatically update all links on opening a workbook,
Without having to click a button saying automatically
update links yes/no...?

Tools - Options - Edit Tab - Remove checkmark in "Ask to update links"


--
mvh.,
Dan Elgaard
http://www.excelgaard.dk/



"walshy" wrote in message
...
Hi,

This is probably simple but is there any way to
automatically update all links on opening a workbook,
Without having to click a button saying automatically
update links yes/no...?

Note that Dan's advice re Tools / Options / Edit / Ask to update
automatic links applies to ALL workbooks you open.

If there are some where the time to update links would be excessive you
might regret making that change.

An alternative is to have another workbook open the real one by using a
macro:

Sub Auto_OPen()
Application.OnTime Now, "Continue_Open"
End Sub

Sub Continue_Open()
Workbooks.Open ThisWOrkbook.Path & "\RealBook.xls", UpdateLinks:=3
ActiveWorkbook.RunAutoMacros xlAutoOpen ' if RealBook has an Auto_Open
ThisWorkbook.Close False
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup