Fix Excel Source Not Found Error When Updating External Links
Question details
The user needs to update Excel external links when Excel reports that the source cannot be found.

- 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.
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.
Reconnect the Excel link to the correct source workbook
Use this method when the workbook stores an outdated or incorrect source path.
In Excel, select File > Open and open the source workbook. Leave it open while you work on the target workbook.
Open the target workbook and select Data > Edit Links. In newer Excel versions, select Data > Workbook Links instead.
Select the affected link, choose Change Source, and browse to the correct source workbook. Confirm the selection.
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.

Check formulas and test for workbook-specific link damage
Use this method if reconnecting the correct file does not resolve the error.
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.

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.




