Fix Excel External Workbook Links Showing N/A After Reopening
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.
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.
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.
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.
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.
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.
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.

Trace N/A errors in the source and destination formulas
Use this if the link points to an accessible workbook but the affected cells still show N/A.
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.

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.




