|  

» Canceling the Update Links Message While Opening a Linked Workbook in Excel 2007

CATEGORY - Excel General VERSION - Microsoft Excel 2007
To cancel the Update Links message while opening a linked workbook:

1. Select File -> Excel Options -> Trust Center -> Trust Center Settings button in Microsoft Office Excel Trust Center section.
2. In External Content check Disable automatic update of Workbook links radio button.



To cancel the displaying of the alert of automatic updating links for a workbook on startup:

1. Select Data -> Edit Links to Files (in Manage Connections Group).
2. In Edit Links dialog box click Startup Prompt button.
3. Check Dont display the alert and update links radio button.



Rate This Tip
12 34 5
Rating: 4.00     Views: 1738
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments