How to Fix Excel Cannot Find an Old File Path Error
Question details
The user needs to stop Excel from prompting about an obsolete file path that cannot be found when opening a specific file.

- Product
- Microsoft Excel, OneDrive for Business
- Device & OS
- not provided
- Scenario
- Opening a frequently used workbook stored in OneDrive for Business that contains hidden or outdated external references.
- Observed behavior
- Excel repeatedly reports that it cannot find an old file path upon opening the workbook, despite the path not being visible in any standard worksheet formulas.
Before modifying the workbook connections, verify whether the external source file was intentionally moved or deleted, as breaking links will permanently convert those formula references into static values.
Locate and Break the Obsolete External Link
Use the Edit Links tool to identify and remove outdated external references that are triggering the missing file path error.
External links can exist independently of standard cell formulas, occasionally hiding inside named ranges, data validation rules, or chart data series. Using the built-in link manager allows you to inspect the status of all workbook connections.
Open the affected workbook in Excel. Navigate to the Data tab on the ribbon and click on Edit Links in the Queries & Connections group.
In the Edit Links dialog box, click on Check Status to see which referenced file paths are broken or no longer reachable.
Select the obsolete file path from the list and click Break Link. A prompt will appear confirming that formulas will be converted to current values; click Break Links to proceed.

Fix External Link Errors with WPS Spreadsheet
WPS Spreadsheet provides powerful and intuitive tools for managing external references, allowing you to easily locate, update, or break obsolete links without the hassle of missing file path errors.
- 1. Open the workbook in WPS: Launch WPS Office and open your spreadsheet file.
- 2. Navigate to the Data tab: Click on the Data tab located in the top menu ribbon.
- 3. Open Edit Links: Click the Edit Links option to view all active and broken external connections.
- 4. Remove the bad links: Select the invalid file path and click Break Link to permanently resolve the missing path error.

Frequently Asked Questions
Where else can external links hide if they aren't in cell formulas?
If they are not in standard formulas, external links frequently hide in defined names (Name Manager), Data Validation lists, Conditional Formatting rules, Chart data series, or shapes and objects assigned to external macros.
Why didn't saving the Excel file to a new location fix the file path error?
Saving the workbook to a new location only changes the directory of the current file. It does not update or remove the hardcoded internal links to external source workbooks that have been deleted or moved.
What happens to my data when I break a link in Excel?
When you break an external link, any formula in your workbook that references the external source is permanently replaced by its currently calculated static value, and the connection to the missing file is severed.




