MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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