To cancel the Update Links message while opening a linked workbook:
1. From the Tools menu, select Options, and then select the Edit tab.
2. Deselect the Ask to update automatic links checkbox, and then click OK.
New in Excel 2002 and Excel 2003:
Choose one of three new options in the Startup Prompt dialog box:
From the Edit menu, select Links, and then click Startup Prompt.
Screenshot // Canceling the Update Links Message While Opening a Linked Workbook
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
This has the effect of always updating links when opening. I want to set AskToUpdateLinks to False but not automatically update links when opening. There is a Startup option in Excel 2002 but I need to do this in Excel 2000. Thanks.
This has the effect of always updating links when opening. I want to set AskToUpdateLinks to False but not automatically update links when opening. There is a Startup option in Excel 2002 but I need to do this in Excel 2000. Thanks.