Formula Errors

Fix Excel External Workbook Links Showing N/A After Reopening

Chanuka GeekiyanageChanuka Geekiyanage Nov 14, 2026 869 views

Question details

The user needs external workbook links to display the correct values after Excel is closed and reopened.

Product
Microsoft Excel
Device & OS
not provided
Scenario
Two linked workbooks are stored on a shared cloud-connected drive.
Observed behavior
The links work initially but show N/A after Excel is reopened, even when both workbooks are open.
Before you start

Confirm that both workbooks are accessible and that the cloud drive has finished syncing. Note the source workbook's current name and location before checking the links.

Solution 1Recommended

Check and update the external workbook link

Use this when a source workbook may have moved, been renamed, or been opened from a different synced location.

1
Inspect the formula

Select an affected cell and check the formula bar for the source workbook name and referenced sheet or cell. Confirm that they match the current source workbook.

2
Review workbook links

In the destination workbook, open Data > Workbook Links or Data > Edit Links, depending on your Excel version. Find the source workbook and review its path and status.

3
Change the source if needed

If the listed path or filename is outdated, use Change Source in the link controls and select the current source workbook from the synced location.

4
Update and test the link

Use the link controls to update the values, then save and reopen the destination workbook. Open both files from the same consistent synced location and check the affected cells.

Check and update the external workbook link
Cloud paths can differ: A shared drive may appear under different local paths or cloud locations. Make sure the destination workbook points to a source that the current user can access.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format compatibility helps you move existing files into your workflow; it does not repair Excel's link settings.

Open and edit Microsoft Excel XLS and XLSX filesReview formulas and spreadsheet references in WPS SpreadsheetUse a familiar interface for an easier transition from Microsoft OfficeKeep everyday document tools together in a lightweight suite
microsoft office alternative - wps office

Frequently Asked Questions

Where can I see the source of an Excel workbook link?

In the destination workbook, select Data > Workbook Links or Data > Edit Links, depending on your Excel version. You can also select an affected cell and inspect its external reference in the formula bar.

Why does the link still show N/A when both workbooks are open?

The link may point to a different copy or outdated path, or the source cell or destination lookup formula may itself return N/A. Check the link source and inspect the referenced cell.

How do I reconnect a moved or renamed source workbook?

Open Data > Workbook Links or Data > Edit Links in the destination workbook, select the affected link, and use Change Source to choose the current source file.

Can a cloud sync location affect workbook links?

Yes. Different local sync paths or cloud locations can make a saved source path inaccessible. Verify that both files are synced and that the link points to the accessible source workbook.