View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Warren Warren is offline
external usenet poster
 
Posts: 5
Default 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