AppGarden External Link and Dependency Mapper logo AppGarden

External Link and Dependency Mapper

Find external links in Excel™ that Edit Links does not show

By Paul Kemp · Published

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

Hunt by hand

These steps apply to Excel™ in Microsoft 365. Work on a copy.

  1. Open Data → Edit Links and note the source files.
  2. Press Ctrl+F, click Options, set Within to Workbook and Look in to Formulas. Search for [ and for .xls. This finds cell formulas.
  3. Open Formulas → Name Manager (Ctrl+F3). Read the Refers To column for paths and file names.
  4. Select the whole sheet and choose Home → Find & Select → Go To Special → Data Validation. Open each validation rule to read its source.
  5. On the Home tab, open Conditional Formatting → Manage Rules, and set "Show formatting rules for" to This Worksheet. Read each rule's formula.
  6. Right-click suspect cells and check Edit Hyperlink for outside paths.
  7. 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.