Find and Fix Broken Links and External References in Excel

Broken external links silently corrupt your formulas. When a source workbook moves, gets renamed, or is deleted, your data goes stale. Upload your file and we'll map every external reference and flag the broken ones.

No signup requiredResults in 30 secondsFile deleted after analysis

Analyze Your Spreadsheet Free

What Are Broken Links?

External references in Excel point to cells in other workbooks — for example, =[SourceFile.xlsx]Sheet1!A1. When that source file moves to a different folder, gets renamed, or is deleted, the reference breaks. Excel then does one of two things: it displays a #REF! error, or — more dangerously — it shows the last cached value that was successfully pulled from the source.

The cached-value scenario is the one that causes real damage. Your spreadsheet continues to show numbers that look current and reasonable. There's no error indicator, no warning, nothing to suggest that the figures are from six months ago. Reports get filed, decisions get made, and the stale data isn't discovered until someone checks the source directly.

Common Causes

Source file moved to a different folder or drive after the links were established
File renamed or reorganized on SharePoint or OneDrive — even minor path changes break stored references
Spreadsheet sent to someone else without including the linked source files
Network drive restructured or mapped to a different drive letter on a new machine
External file deleted or archived as part of a cleanup or migration

Why Excel's Edit Links Isn't Enough

Excel's Data → Edit Links shows you a list of linked source workbooks, which is a useful starting point. But it has significant gaps:

It shows source workbooks, not the individual cells containing the references — you can't see which formulas are affected without searching manually
It doesn't scan named ranges, which can contain external references that don't appear in any cell formula
It doesn't check conditional formatting rules or data validation source lists, both of which can reference external files
It can't reliably distinguish a broken link (file gone) from a link that simply hasn't been refreshed (file exists but data is stale)

What We Scan

Excel Risk Check looks for external references in every place they can hide:

Cell formulas — every formula in every cell on every sheet, including hidden sheets
Named range definitions — named ranges can reference external workbooks and these are invisible in the cell grid
Conditional formatting rules — format conditions that reference cells in other files
Data validation source lists — dropdown lists that pull options from an external workbook

The report lists each external reference with its location, the source path it points to, and a status indicating whether the link appears intact or broken based on the path stored in the file.

Why This Matters for Shared Workbooks

The broken link problem is especially acute when spreadsheets change hands. If you've received a workbook from a colleague, a client, or a third party, there's no way to know whether the external links it contains will resolve on your system. The source files may live on a network share you don't have access to, a personal drive that wasn't included in the handoff, or a path that simply doesn't exist on your machine. Running the external link scan before you rely on the numbers tells you exactly which links you need to investigate.

How to Fix Broken Links After Finding Them

If the source file exists at a new location: use Data → Edit Links → Change Source to repoint to the new file path. Excel will update all formulas that reference that workbook.
If the source file no longer exists: decide whether to replace the external references with static values. Copy the cells in question, then Paste Special → Values to break the link and preserve the last-known numbers. Document that the figures are from a specific date.
If you received the file from someone else: request the source files or ask the sender to break all external links before sending (Data → Edit Links → Break Link). You'll get static values rather than live connections, which is safer when you can't control the source paths.
If the link is to a SharePoint or OneDrive file: verify the file hasn't been moved within the document library. SharePoint path changes break stored Excel references even when the file is still accessible via the web interface.

Frequently Asked Questions

How are broken links different from #REF! errors?

#REF! errors are broken internal references caused by deleted rows or columns within the same workbook. Broken external links reference files that have moved or no longer exist on another workbook. Both can cause incorrect results but they have different causes and fixes. Our tool detects both.

Will Excel tell me if a link is broken?

Sometimes. Excel shows a security bar asking whether to update links on open. But if the source file still exists at the original path, Excel may silently use stale data without any warning. We scan for both clearly broken links and potentially stale ones.

Can broken links be hidden in named ranges?

Yes. Named ranges can contain external references that don't appear in any cell formula but still link to external files. These are commonly missed by manual checks. Our tool scans all named range definitions.

Does this work with SharePoint and OneDrive paths?

Yes. The tool reads the link paths stored in the file regardless of whether the source is on a local drive, SharePoint, or OneDrive.