Tip Printed from ExcelTip.com
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.