Excel Error Codes

Fix Excel Source Not Found Error When Updating External Links

Phi Hung VoPhi Hung Vo Nov 22, 2026 868 views

Question details

The user needs to update Excel external links when Excel reports that the source cannot be found.

Fix Excel Source Not Found Error When Updating External Links
Product
Microsoft Excel
Device & OS
not provided
Scenario
Updating links in a target workbook that references another workbook.
Observed behavior
Excel reports Source Not Found even though the source workbook exists.
Before you start

Locate the source workbook and confirm that it opens separately in Excel. Check that you can access its folder or network location and that you have selected the intended file.

Solution 1Recommended

Reconnect the Excel link to the correct source workbook

Use this method when the workbook stores an outdated or incorrect source path.

1
Open the source workbook

In Excel, select File > Open and open the source workbook. Leave it open while you work on the target workbook.

2
Find the external links

Open the target workbook and select Data > Edit Links. In newer Excel versions, select Data > Workbook Links instead.

3
Change the source

Select the affected link, choose Change Source, and browse to the correct source workbook. Confirm the selection.

4
Update and check the link

In Edit Links or Workbook Links, select the link and choose Update Values or Refresh, as available. Check the affected cells to see whether the error is resolved.

Reconnect the Excel link to the correct source workbook
If the link works only when the source is open: Check the linked formulas. Some functions, such as INDIRECT, cannot retrieve external references from a closed workbook.
Free Microsoft Office alternative

Work with Excel files in WPS Spreadsheets

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Its Excel format compatibility makes it easier to move existing files into your workflow, although it does not repair Excel's external-link errors.

Open and edit spreadsheets in a familiar interfaceWork with Microsoft Excel XLSX and XLS filesReview formulas and spreadsheet data in WPS SpreadsheetsMove existing Office files into a lightweight workspace
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say the source is missing when the file exists?

The stored link may point to an old location or a different filename. Open Data > Edit Links or Data > Workbook Links, select the affected link, and use Change Source to choose the current file.

Why does the link work only when the source workbook is open?

Some formulas require the source workbook to be open. For example, INDIRECT cannot retrieve an external reference from a closed workbook. Inspect the affected formula and consider a reference that works with a closed source.

Where can I find external references outside worksheet cells?

Select Formulas > Name Manager and check the Refers to column for external workbook paths. External references can also appear in objects such as charts.

How can I tell whether the target workbook is the problem?

Create a new workbook and add a simple reference to the same source. If that link works but the original workbook still fails after you reconnect the source, the issue may be specific to the original workbook or its link metadata.