A Complete External-Link Report Beyond Excel's Edit Links Dialog

Edit Links shows nothing; the audit shows a hyperlink

There are no workbook references, so Edit Links is empty — but a cell hyperlinks to an intranet page. Only the full audit catches it.

Edit Links dialog: (no links)

Audit report:
Found 1 external link(s):

1. [hyperlink] https://intranet.example.com/policy

A data connection invisible to Edit Links

Edit Links is for workbook links only; the live SQL connection lives in a different dialog. The audit reports it in the same inventory.

Edit Links dialog: (no links)

Audit report:
Found 1 external link(s):

1. [data_connection] Data Source=sql-rpt-01;Initial Catalog=Ops

All three classes in one report

A mature model with a workbook reference, a docs hyperlink, and a Power Query feed. Edit Links would show only the first.

Audit report:
Found 3 external link(s):

1. [external_ref] file:///\\nas\inputs\drivers.xlsx
2. [hyperlink] https://docs.example.com/methodology
3. [data_connection] Provider=Microsoft.Mashup.OleDb.1;...

Edit Links lists a link the audit also confirms

When a workbook reference exists, both agree on it — but only the audit adds the hyperlink and connection context around it.

Edit Links dialog: drivers.xlsx (Status: OK)

Audit report:
Found 1 external link(s):

1. [external_ref] file:///\\nas\inputs\drivers.xlsx

Clean across all three classes

The full-audit equivalent of a totally self-contained workbook: no references of any kind.

Audit report:
No external links found in this workbook.

Edit Links shows only workbook references, so a file whose only external links are hyperlinks or data connections appears 'clean' there. The full audit reports those classes too — the entire reason to use it over the built-in dialog.

The report lists type and target, not the cell or sheet. To locate a link in Excel, copy the target string and use Ctrl+F. The audit's contribution is completeness of the inventory, not cell-level mapping; for dependency tracing use the Dependency Map.

The auditor reports the connection entry from xl/connections.xml (the connection=/odcFile= value), not the full M code stored in the query parts. You learn that a connection exists and its connection string — sufficient for an audit and more than Edit Links ever offered. Inspect the M in Power Query Editor for the full query.

Shape- and image-anchored hyperlinks live in xl/drawings/_rels/*.rels, outside the cell-hyperlink relationships the scan reads. The audit covers cell hyperlinks, workbook references, and connections — review embedded objects separately.

Such a name needs an externalLinks relationship, so its target appears as external_ref even though Edit Links may present it confusingly. The audit confirms the external file is referenced; remove the name in Formulas → Name Manager to clear it.

Hyperlink relationships are stored per-worksheet regardless of visibility, and externalLinks/connections.xml are workbook-level, so links on hidden or very-hidden sheets still appear in the report — broader than what you'd find clicking through visible tabs. To remove those sheets, use the Hidden Sheet Destroyer.

An open-password-encrypted file is an encrypted container JSZip can't unpack, so no parts are scanned. Remove the password in Excel, then audit. To evaluate that password's strength, see the Password Entropy Auditor.

Legacy .xls (OLE) and binary .xlsb are not OOXML ZIP containers and can't be read. Save as .xlsx first, then run the full audit.

If a macro builds an external reference when the file opens, there's no static part to scan at rest. The audit reflects the file's stored state. Strip macros with the VBA Macro Stripper for a deterministic, link-free file.

When none of the three scanned parts carries a target, the report is No external links found in this workbook. Across all three classes — workbook links, hyperlinks, connections — the file is clean, a stronger statement than an empty Edit Links dialog.