Open workbook without update all linked information

  • Thread starter Thread starter Warren
  • Start date Start date
W

Warren

I am writing a macro which opens and closes a series of workbooks. One of
the workbooks contains formula that have links to other workbooks. So, the
macro stops when it tries to open this workbook and ask if I want to update
all linked information.

Is there a code that specifically tells Excel to open workbooks and if it
contains links, do not update all the linked information?

I think this works:
Application.DisplayAlerts = False
But this one surpresses all alerts.

Thanks in advance

Warren
 
I don't believe displayalerts works in this case. What does work is the
second argument to the workbooks.open method

workbooks.open filename:="Whatever", UpdateLinks:=0
 
Back
Top