Excel Phantom Links
"Phantom link" is the name people give a specific, maddening version of this problem: Excel shows the "this workbook contains links to other data sources" warning every time you open the file, but Data → Edit Links shows an empty list, or a source you already removed. The link isn't gone — Excel just isn't showing you where it is.
Why phantom links happen
Cached reference data
Excel sometimes caches metadata about a link even after the visible reference is removed, particularly if the removal was partial (see the previous point about Break Links not always reaching named ranges). The warning persists because, internally, a trace of the link remains.
Named ranges Edit Links doesn't surface
The Edit Links dialog primarily reflects formula-level external references. A named range whose "refers to" points externally can keep triggering the workbook-level warning without ever appearing in that dialog at all.
Hidden or very hidden sheets
A reference living on a hidden (or very hidden, set via VBA) sheet is still a real reference — Excel will still warn about it — but you won't stumble onto it by clicking through visible tabs.
Chart and data validation sources
As with Break Links, chart series and data validation rules can hold external references that live outside what Edit Links inspects.
How to hunt one down
- Unhide all sheets first (right-click any tab → Unhide) — check for very hidden sheets via the VBA editor's Project Explorer if you suspect one.
- Check Formulas → Name Manager for any "Refers to" value with a file path or brackets.
- Search formulas (
Ctrl+F, search within Formulas) for.xlsx,.xls, or[. - Review every chart's data source on every sheet.
If all of that comes up empty and the warning still won't go away, the reference is genuinely hard to spot by hand — which is the situation a direct structural scan is built for.
Sheetopsy and phantom links
Rather than relying on Excel's own (incomplete) Edit Links view, Sheetopsy reads the workbook's underlying file structure directly — the same data Excel itself stores — and lists every external reference in formulas and named ranges, with its exact location, so a phantom link stops being a mystery.