Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

linked cells in another workbook

Posted by Steve W on March 31, 2001 2:05 PM

Is there a way to not have the message box pop up asking you if you want to update links, when theres links to other workbooks in the workbook.

Thanks steve

Re: linked cells in another workbook

Posted by ml on April 02, 2001 11:27 AM

Do you want them to automatically update without asking?
That's under Tools->Options->Edit->
Ask to update automatic links.

If not, then if you can't go to Edit->Links
and change your links to manual instead of automatic,
you are out of luck

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.