How to Find External Links in Excel

An external link is a formula that pulls a value from another workbook, like =[Budget.xlsx]Sheet1!A1. They are useful while you build, but a file full of them breaks the moment those source files move. Here is how to find every external link before it causes a problem.

Check the Edit Links dialog

Excel keeps a list of every workbook your file links to. This is the fastest way to confirm whether external links exist at all.

1. Open the Data tab.
2. In the Queries & Connections group, click Edit Links.
3. Review the list of source files. If the button is greyed out, the workbook has no external links.
4. Click a source and use Check Status to see whether the linked file is still reachable.

Search formulas for the bracket character

External references always wrap the source file name in square brackets, so the [ character is a reliable signal. Press Ctrl+H, type [ in Find what, set Look in to Formulas, and click Find All. Excel lists every cell whose formula contains a bracket, which points you straight to the linking cells the Edit Links dialog only summarizes.

Why finding the cell matters

Edit Links tells you which files you depend on, but not which cells do the linking. On a large sheet, tracking down the actual formula behind a broken link can take ages. The bracket search helps, but it also flags structured-reference tables and other legitimate uses of brackets, so you still have to sort through the results.

Locate and resolve links with ModelMint

ModelMint Hardcode Links focuses on the real problem: formulas that link to another workbook, like =[Book.xlsx]Sheet1!A1. It converts each one into its current value so the file no longer depends on outside files. If your goal is to find external links in order to sever them, this turns a hunt-and-fix chore into a single action. It targets external workbook links, not Bloomberg or other data-provider functions.