How to Find External Links in Excel

Excel warns you when a workbook contains links to other files ("This workbook contains links to other data sources"), but it doesn't make it easy to see exactly where those links live. Here are the manual methods that actually work, what each one misses, and a faster option at the end.

Method 1: Data → Edit Links

The built-in starting point. Go to Data → Queries & Connections → Edit Links (older versions: Data → Edit Links to Files). This lists every external source file the workbook knows about.

What it misses: source file names only — not which sheet, cell, or named range references them. On a large workbook, that leaves you exactly where you started: knowing a link exists, with no idea where.

Method 2: Find & Replace on formulas

Ctrl+F → Options → search within Formulas, searching for .xlsx or [ (external references are wrapped in square brackets, e.g. [Budget.xlsx]). This works reasonably well for formula references, one sheet at a time.

What it misses: named ranges. Find & Replace only searches cell formulas — it never looks inside Name Manager, so a named range that refers to an external file slips through completely, even though it can still drive formulas elsewhere in the workbook.

Method 3: Formulas → Name Manager

Open Formulas → Name Manager and scan the "Refers to" column for any entry containing square brackets or a file path. This is the only manual method that actually surfaces external named ranges.

What it misses: nothing structurally, but it doesn't scale. A workbook with 80+ named ranges means reading 80+ "Refers to" strings by eye, and it's easy to skim past one.

Method 4: Check the raw XML

A .xlsx file is a zip archive of XML files. Renaming a copy to .zip, extracting it, and grepping xl/workbook.xml and xl/worksheets/*.xml for external-reference patterns will find everything — formulas and named ranges alike — but it requires comfort with raw OOXML markup and isn't something most people want to do for one broken link.

The faster way

This is exactly what Sheetopsy automates: it reads the same underlying workbook structure Method 4 describes, entirely in your browser, and lists every external reference in formulas and named ranges with its exact sheet, cell, or name — in seconds, with nothing uploaded anywhere.