Canceling the Update Links Message While Opening a Linked Workbook

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
Canceling the Update Links Message While Opening a Linked WorkbookCanceling the Update Links Message While Opening a Linked Workbook

Users are saying about us...

  1. 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.

  2. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube