Excel External Link Finder — Locate Every Hidden Reference
An external link in Excel is any formula, named range, chart, or validation rule that points at data in a different workbook file. They're useful when you're actively building a linked model — and a liability the moment that other file gets renamed, moved, or deleted, because Excel keeps the reference and just quietly breaks (or worse, keeps showing stale cached numbers).
What counts as an external link
Two places external links commonly live, and the two Sheetopsy checks today:
- Formulas that reference another workbook by name, e.g.
='[Budget.xlsx]Sheet1'!$B$19. - Named ranges (Name Manager) whose "refers to" value points at an external file — these are the ones people miss most often, because a normal
Ctrl+Fsearch across formulas never touches them.
Charts, data validation rules, conditional formatting, and pivot table sources can also hold external references — those are out of scope for the current version, and Sheetopsy says so plainly rather than pretending otherwise.
Why they're hard to find by hand
Excel's own Edit Links dialog (Data → Edit Links) tells you a workbook has external references and lists the source file names — but not where in the workbook each one lives. For a model with a handful of sheets and a few dozen named ranges, finding the actual cell or name manually usually means opening Name Manager, scrolling through every formula, and cross-referencing by eye. It's slow, and it's easy to miss one.
How Sheetopsy finds them
Drop a .xlsx or .xlsm file into the scanner. It reads the workbook's internal structure directly in your browser — the same underlying XML Excel itself writes — and lists every external reference it finds: which sheet, which cell (or which named range), and which external file it points to. Nothing leaves your device.
Frequently asked questions
Does Sheetopsy tell me if a link is broken?
No. A browser can't check whether a file still exists at a path on your computer, so Sheetopsy never claims a link is BROKEN or ACTIVE. It reports FOUND — the reference exists in the workbook, and here's exactly where — which is what actually matters when you're hunting for one.
Is my workbook uploaded anywhere?
No. Everything runs in your browser using JavaScript. The file is read locally and never sent to a server, storage bucket, or third party.
What file types are supported?
.xlsx and .xlsm workbooks.
Does it check charts, data validation, or conditional formatting?
Not yet. The current version checks formulas and named ranges, which cover the large majority of hidden external references. Chart sources, data validation rules, and conditional formatting are planned for a future version.