Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

Disable Automatic Link to External Workbooks

Posted by Todd on August 16, 2001 8:56 AM

I want to disable the message that pops up when opening a new workbook with links to external workbooks. Is there anyway that I can do this?

I tried Options and setting update to Manual; but I still get the message if I want to update the workbook with the external data when I open it.

Thank you for help.

Re: Disable Automatic Link to External Workbooks

Posted by Bryan Harris on August 16, 2001 9:13 AM

In Excel '97:

Select Tools, Options, Edit

De-select "Ask to Update Automatic Links"

This should allow the workbook to open without asking you that "Annoying" question.

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.