Show All

Check status of and fix links

1. On the Edit menu, click Links.

   The Links command is unavailable if your file does not contain linked information.

2. Click Check Status to update the status for all links in the list. This may take a while if there are a lot of links, or if the source workbook for the links is on a network location, and the network is slow.

3. Check the status in the Status column, select the link, and then take the action needed.

   OK    No action required, the link is working and up to date.

   Unknown Click Check Status to update the status for all links in the list.

   Not applicable    The link uses Object Linking and Embedding (OLE) or Dynamic Data Exchange (DDE). Microsoft Excel cannot check the status of these types of links.

   Error: Source not found    Click Change Source, and select another workbook.

   Error: Worksheet not found    Click Change Source, and then select another worksheet. The source may have been moved or renamed.

   Warning: Values not updated    Click Update Values. The link was not updated when the workbook was opened.

   Warning  Click Open Source, and calculate the workbook by pressing F9. The workbook may be set to manual calculation. To set to automatic calculation, on the Tools menu, click Options, select the Calculation tab, and then click Automatic.

   Warning  Some names cannot be resolved until the source workbook is opened. Click Open Source, switch back to the destination workbook, and click Check Status. If this does not resolve the problem, make sure the name is not misspelled or missing. Switch to the source workbook, and then on the Insert menu, point to Name, and then click Define, and look for the name.

   Warning  Click Open Source. The link cannot be updated until the source is open.

   Source is open    The source is open. No action required unless worksheet errors are present.

   Values updated from filename No action required, the values have been updated.

   Warning  Excel cannot determine the status of the link. The source may contain no worksheets, or be saved in an unsupported file format. Click Update Values.