Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid "...contains one or more links that cannot be updated" message.
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 :-) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid "...contains one or more links that cannot be updated" message.
Craig wrote:
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. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I avoid "server busy" message during ole automation | Excel Discussion (Misc queries) | |||
#VALUE! show up on "non-updated" links to another sheet | Excel Discussion (Misc queries) | |||
Avoid "update Links" promt in e-mailed pivot tables? | Excel Discussion (Misc queries) | |||
How to avoid "update links" startup prompt? | Excel Discussion (Misc queries) | |||
How to avoid "large data on clipboard" message? | Excel Programming |