Avoid "...contains one or more links that cannot be updated" message.

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I use Excel2002 & I use code to sequentially open, refresh, save &
close 30 files from a master Excel file. On opening each file the
message appears "This workbook contains one or more links that cannot
be updated." I have a choice of buttons 'Continue' or 'Edit Links'.
The links are ok so I want to avoid this message.

Thankyou in advance :-)
 
Craig said:
On opening each file the
message appears "This workbook contains one or more links that cannot
be updated." I have a choice of buttons 'Continue' or 'Edit Links'.
The links are ok so I want to avoid this message.
Click to expand...

Try
Application.DisplayAlerts = False
Workbooks.Open TheFileName, UpdateLinks:=0
Application.DisplayAlerts = True

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top