Open workbook without update all linked information
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
|