Find External Links in Excel

What this does

An external link is a reference to another workbook, written with the file name in square brackets: ='C:\Budget\[2026.xlsx]Sheet1'!$B$4. Edit Links names every source file but does not show you where the references sit, and it is blind to three hiding places that produce the maddening "this workbook contains links" prompt with an apparently empty link list: defined NAMES (Formulas ▸ Name Manager, look for [ in the Refers To column), CHART series formulas, and data-validation or conditional-formatting rules that point at another file. Searching the workbook for the [ character with Look in: Formulas finds the cell references; the other three have to be checked in their own dialogs. Break Links replaces every external reference with its current value — permanently, and Undo will not bring the formulas back. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. For “find external links in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a data step that keeps your analysis trustworthy useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

A report prompts to update links on every open. Data ▸ Edit Links lists Prices.xlsx, but Ctrl+F for [ in Formulas across the workbook finds nothing. Formulas ▸ Name Manager shows a name Cost_Base whose Refers To reads ='[Prices.xlsx]Rates'!$A$1 — deleting or repointing that name clears the prompt. Links to a file someone has since moved are one of the commonest reasons a workbook shows stale numbers, and finding them is the part Excel makes hardest. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

In Google Sheets

References to another workbook do not carry over: Excel's [Workbook.xlsx]Sheet1!B4 syntax is not valid in Google Sheets, where data from another spreadsheet is pulled in with IMPORTRANGE. References to another tab in the same file (Sheet2!B4) work in both. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. If you take one thing from this page on “find external links in excel”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.

Common mistakes

• Searching for the file name instead of [ — the stored path may differ from the name you remember.
• Leaving Look in: on Values, which finds results rather than the formulas containing the links.
• Breaking links without a backup, converting every external formula to a static value irreversibly.
• Assuming an empty Edit Links list means no links; names, charts and rules are not listed there.
• Moving the source workbook and expecting the link to follow it — the path is stored, so the link breaks.

Frequently asked questions