EXCEL EXTERNAL LINK CHECKER · BREAK EXTERNAL LINKS
An Excel external link checker that finds every hidden reference.
External links to other Excel workbooks are some of the most fragile parts of a model. They break when files move, return stale values when the source is offline, and live in places Excel's own "Edit Links" dialog doesn't always show. The Excel external link checker finds them all — cells, named ranges, conditional formats, data validation, charts — and lets you decide what to do.
Free tier — 30 audits/month — no card required.
External links are the source of "why is this number different?"
A workbook with external links works fine on the original computer, in the original folder structure. Send it to a colleague and the links break — or worse, they return stale cached values that look right but are off by a quarter. Restructure your file folders and you spend the next hour clicking through Excel's repair dialogs.
Excel's built-in Edit Links dialog catches the most obvious cell-level links. It misses links embedded in named ranges, conditional formatting rules, data validation, chart series, and pivot table sources. A proper Excel external link checker walks every one of those layers.
How the link check runs
- 1
1. Upload
Drop your .xlsx. SaferSheets parses every formula, named range, conditional format, validation rule, chart series, and pivot source.
- 2
2. Inventory every external reference
Each external link is listed with its source location, the cell or object it lives in, and the workbook it points to (file path or URL).
- 3
3. Severity by reachability
Reachable + same value as cached → low risk. Reachable + value differs → critical. Unreachable → flagged but might still be returning stale cached data.
- 4
4. Break or replace
Optionally generate a corrected copy that converts external references to their last-known values, with cell comments noting the original link.
Where external links hide
Excel's built-in Edit Links dialog typically surfaces only the cell-formula references. SaferSheets walks every other layer too.
Cell formula references
='[OtherWorkbook.xlsx]Sheet1'!A1 — the standard pattern. Listed with the cell location and the target workbook path.
Named ranges pointing externally
A name defined as ='[Source.xlsx]Sheet1'!$A:$A — every formula using that name is implicitly an external reference. The link checker lists both the name definition and the formulas that depend on it.
Conditional formatting rules
Rules like "highlight if value > '[Targets.xlsx]Sheet1'!B2" — external link buried in the formatting layer. Easy to miss with a manual review.
Data validation
Drop-downs sourced from another workbook's range. When the link breaks, the drop-down silently stops working or shows stale options.
Chart series
Chart data series pointing at ranges in another workbook. Often resolves to the last-cached values; chart updates lag the source.
Pivot table sources
Pivots pointing at an external workbook as their source range. Refresh requires the source; refresh failure produces a stale pivot that still looks alive.
OLE / embedded objects
Linked-and-embedded Excel objects pointing at another file. Flagged with the target path so you can verify.
Hyperlinks to external files
HYPERLINK formulas pointing at network paths or other workbooks. Surface for review (some are intentional documentation links, others are stale).
Frequently asked questions
Why doesn't Excel's own Edit Links dialog show everything?
+
Excel's Edit Links surfaces cell-formula references but not links embedded in named ranges, conditional formatting, data validation, chart series, or pivot sources. Those layers store references separately. To find every external reference you have to walk each layer — which is what the SaferSheets link checker does automatically.
Can I break the links and replace them with values?
+
Yes. Optionally generate a "link-free" copy that converts every external reference to its last-known value, with a cell comment recording what the original reference was. Useful for sending workbooks to people who don't have access to the source files, or for freezing a snapshot for archival purposes.
Does it detect links to OneDrive / SharePoint files?
+
Yes. Cloud-hosted source links look like https://contoso.sharepoint.com/... in the link target — the checker recognizes the pattern and lists them like any other external reference. Reachability check skips network calls (we don't fetch your SharePoint files) but the target URL is recorded.
What about links to Google Sheets via IMPORTRANGE?
+
IMPORTRANGE references are detected when the audit is run against a Google Sheet (not an Excel file). For Excel files, native cross-workbook formula references are the equivalent. Both surface in the audit.
Will it leave my file as-is by default?
+
Yes. The link checker is read-only. Generating a link-free copy is an explicit step you choose — and even then, it produces a new file rather than modifying the original.
Further reading
Deep-dives from the SaferSheets blog
Hidden risks
Why Excel External Links Break When You Share Files
Learn why Excel external links break when you share files and how to check your workbook before sending it to clients or colleagues.
2 min read
Hidden risks
Why Hidden Sheets Are Dangerous in Excel Files
Hidden sheets in Excel can contain outdated assumptions, sensitive data, or calculations that affect reports. Learn why they matter and how to review them.
2 min read
Audit your next spreadsheet before you send it.
Free tier covers 30 audits a month. No card. Sign in with Google and you're running in under a minute.
Audit. Validate. Trust your data.
Related tools
- Excel audit toolFull audit of any Excel workbook in seconds.
- Spreadsheet error checkerCatch broken cells, bad references, and silent risks.
- Excel formula checkerFind every broken or risky formula in a workbook.
- Inherited workbook auditAudit a spreadsheet you didn't build before relying on it.
- Compare Excel workbooksDiff two versions of the same file, ranked by risk.
- Google Sheets audit toolAudit any Google Sheet for the same errors as Excel.