MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Update Link Automatically without a PROMPT, and clicking YES


Posted by Chris on November 21, 2001 3:57 AM

Two questions really:

Am I missing something? Is there a SEARCH the message board somewhere? If there was I would search before I ask because I bet this question has been asked before..

When I open an EXCEL it ask to UPDATE LINKS, can I tell or write a macro to SAY "YES" all the time when the sheet is opened?


Posted by Daniel P. on November 21, 2001 4:57 AM

Re: Update Link ... tools-options-edit tab...

There is a search under the main page but I haven't had any luck either.

I think this is what you need. Under tools, select options, go to the "Edit" tab and uncheck the "Ask to update automatic links".

This should update automatically without asking.

Daniel P.

Posted by Chris on November 21, 2001 5:56 AM

Re: Update Link ... tools-options-edit tab...

Thank you!