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

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 :)
 
B

Bill Manville

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bypass information 1
XL03: Avoid "workbook contains links" msg when opening 5
Links cannot be updated 1
Avoid displayalert message while opening file 3
Edit Links in Excel 2007 4
User Intervention Required When Opening Workbooks 1
workbook contains one or more links that cannot be updated 9
Where is the link? (non-rectangular reference) 4

Top