Archive of Mr Excel Message Board
Back to Links in Excel archive index
Back to archive home
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?
Re: Update Link ... tools-options-edit tab...
Posted by Daniel P. on November 21, 2001 4:57 AM
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.
Re: Update Link ... tools-options-edit tab...
Posted by Chris on November 21, 2001 5:56 AM
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.