File Cannot Open

How to Fix Excel Cannot Find an Old File Path Error

Olivia MillerOlivia Miller Oct 26, 2026 872 views

Question details

The user needs to stop Excel from prompting about an obsolete file path that cannot be found when opening a specific file.

How to Fix Excel Cannot Find an Old File Path Error
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 you start

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.

Solution 1Recommended

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.

1
Access the Edit Links menu

Open the affected workbook in Excel. Navigate to the Data tab on the ribbon and click on Edit Links in the Queries & Connections group.

2
Check the status of existing links

In the Edit Links dialog box, click on Check Status to see which referenced file paths are broken or no longer reachable.

3
Break the broken link

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.

Locate and Break the Obsolete External Link
Hidden References: If the Edit Links button is grayed out or the error persists, the old path might be trapped in a defined name. Go to Formulas > Name Manager to review and delete any named ranges containing the obsolete file path.
Manage Workbook Links Easily

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. 1. Open the workbook in WPS: Launch WPS Office and open your spreadsheet file.
  2. 2. Navigate to the Data tab: Click on the Data tab located in the top menu ribbon.
  3. 3. Open Edit Links: Click the Edit Links option to view all active and broken external connections.
  4. 4. Remove the bad links: Select the invalid file path and click Break Link to permanently resolve the missing path error.
Easily inspect and break outdated external links to stop startup errorsFully compatible with Microsoft Excel formats (.xls, .xlsx, .csv)Clear Name Manager interface to quickly find hidden reference pathsLightweight architecture ensures fast loading of complex workbooks
microsoft office alternative - wps office

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.