How to Find Links to Other Workbooks in Excel

A workbook link is any formula that reads from a separate Excel file, recognizable by the file name in square brackets like =[Forecast.xlsx]Inputs!B2. Before you share or finalize a file, you need to find every one of these dependencies. Here is how.

Start with the Edit Links dialog

The quickest check for whether any workbook links exist at all is the Edit Links dialog.

1. Open the Data tab.
2. Click Edit Links in the Queries & Connections group.
3. Read the list of source workbooks. If the button is greyed out, there are none.
4. Use Check Status to see which sources are still reachable and which are broken.

Find the linking cells with a bracket search

Edit Links names the files but not the cells. Because every workbook reference wraps the file name in square brackets, you can locate the formulas with Find & Replace. Press Ctrl+H, enter [ in Find what, set Look in to Formulas, and click Find All to list every linking cell on the sheet.

Check defined names and other hiding spots

Workbook links also live outside cells. Open the Name Manager (Ctrl+F3) and look in the Refers To column for paths in brackets. Chart series, conditional formatting, and data validation can each carry a link too, which is why a link sometimes appears in Edit Links even when a bracket search finds nothing in the cells.

Find and resolve every link with ModelMint

ModelMint Hardcode Links zeroes in on formulas that link to another workbook, like =[Book.xlsx]Sheet1!A1, and converts each one to its current value so the file no longer depends on external files. When the reason you are finding links is to remove them, this collapses the find-then-fix process into a single step. It targets external workbook links, not data-provider functions like Bloomberg.