Find external links in Excel™ that Edit Links does not show
Open a workbook and Excel™ may offer to update links. Data → Edit Links shows a list of source files. It does not tell you where in the workbook each link lives, and Ctrl+F will not find all of them.
Where links hide
- Cell formulas, the obvious place.
- Defined names that refer to another file.
- Data validation lists that read options from another workbook.
- Conditional formatting rules that point at another file.
- Hyperlinks that open files or folders outside the workbook.
Hunt by hand
These steps apply to Excel™ in Microsoft 365. Work on a copy.
- Open Data → Edit Links and note the source files.
- Press Ctrl+F, click Options, set Within to Workbook and Look in to Formulas. Search for
[and for.xls. This finds cell formulas. - Open Formulas → Name Manager (Ctrl+F3). Read the Refers To column for paths and file names.
- Select the whole sheet and choose Home → Find & Select → Go To Special → Data Validation. Open each validation rule to read its source.
- On the Home tab, open Conditional Formatting → Manage Rules, and set "Show formatting rules for" to This Worksheet. Read each rule's formula.
- Right-click suspect cells and check Edit Hyperlink for outside paths.
- Repeat on every sheet. Hidden sheets count.
This is slow, which is why links are often missed.
Scan the whole workbook
External Link and Dependency Mapper reads cell formulas, defined names, validation lists, conditional formats and hyperlinks in one pass and reports the exact location of each, with a coverage note saying what could not be inspected, such as charts, shapes, pivot caches and Power Query. Scanning the whole workbook and reading the report are free and unlimited. Your workbook is not uploaded.
See External Link and Dependency Mapper for Excel™
Microsoft, Excel and Microsoft 365 are trademarks of the Microsoft group of companies. External Link and Dependency Mapper is not affiliated with or endorsed by Microsoft.