MrExcel Publishing
Your One Stop for Excel Tips & Solutions

message to disappear

Posted by Andonny on May 25, 2001 4:18 PM

I have following message when I open the workbook:
The workbook you opened contains automatic links to information in another workbook. Do you wnat to update this workbook with.......
Yes No

How can I stop this message to appear when I open the workbook.


Posted by Kevin James on May 25, 2001 5:15 PM


You can do so by noting the links it is referring to and then searching the file for those links and deleting them.

CAUTION: These links are most probably tied to formula so the cells that need the link will no longer provide the correct answers.

To understand this feature, use Excel help and look for subject:
About using formulas to calculate values on other worksheets and workbooks


Posted by Dave Hawley on May 25, 2001 5:17 PM

Hi Andonny

You can stop the message by opening the Workbook with code. eg;

Workbooks.Open Filename:="Book1.xls", UpdateLinks:=0

The arguments for UpdateLinks are:

0 Doesn't update any references
1 Updates external references but not remote references
2 Updates remote references but not external references
3 Updates both remote and external references


OzGrid Business Applications