Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

message to disappear

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

Hi,
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.

Thanks
Andonny

Re: message to disappear

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

Andonny:

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

Kevin

Re: message to disappear

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

Dave

OzGrid Business Applications

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.