When you try to open a Microsoft Excel workbook, you may receive a message that resembles one of the following messages, depending on the version of Excel that you are running.
Microsoft Office Excel 2007
Security Warning Automatic update of links has been disabled.
If you click
Options, click
Enable this content, and then click
OK, you receive the following message:
Excel cannot update one or more links in this workbook. To update the links, open all the link source files (click Edit Links on the Data tab). To be sure all calculations are updated, press F9.
To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:
When you click
OK, you then receive the following message:
This workbook contains one or more links that cannot be updated.
* To change the source of links, or attempt to update values again, click Edit Links.
* To leave the links as is, click Continue.
To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:
Microsoft Office Excel 2003
This workbook contains links to other data
sources.
* If you update the links, Excel attempts to retrieve the
latest data.
* If you don't update, Excel uses the previous
information.
If you click
Update, you receive the following error message:
This workbook contains one or more links that cannot be updated.
* To
change the source of links, or attempt to update values again, click Edit
Links.
* To open the workbook as is, click Continue.