How to find what's triggering excel's 'update links?' warning
- Step 1Audit the file that keeps prompting — Drop the offending
.xlsxonto the tool. JSZip unpacks the OOXML container in your browser and scansxl/externalLinks/_rels/*.rels, the worksheet_relshyperlink relationships, andxl/connections.xml. - Step 2Read the inventory and identify the source — The report lists
Found N external link(s):then numberedn. [type] urllines. Anexternal_refordata_connectionentry is almost always what's driving the prompt — note its exact target string. - Step 3Hunt the reference in Excel — Use Ctrl+F and paste the file token from the report (e.g.
[Source.xlsx]). Search formulas, and check defined names under Formulas → Name Manager — references can hide there even when no cell visibly uses them. - Step 4Break the workbook references — Use Data → Edit Links → Break Link for each external workbook reference. If Break Link won't clear it, delete the offending defined name in Name Manager, then save and re-audit.
- Step 5Remove lingering data connections — Under Data → Queries & Connections, delete any connection you don't need — a stale connection in
xl/connections.xmlcan keep the prompt alive on its own. Save the file afterward. - Step 6Re-audit to confirm the prompt is gone — Drop the cleaned file back onto the auditor. A
No external links found in this workbook.result means the OOXML parts that fed the warning are gone — the prompt should no longer appear on open.
Why the prompt persists and where to look
Common reasons the 'Update Links?' warning survives a Break Link attempt, mapped to the report label that exposes the cause.
| Hiding place | Report label that exposes it | Why Edit Links may miss it | How to clear it |
|---|---|---|---|
Leftover externalLinks part with a relationship target | external_ref | Break Link sometimes leaves the package part behind | Re-run Break Link, or delete the related defined name, then re-save |
| Defined name referencing another workbook | external_ref | Edit Links shows the workbook but not which name uses it | Formulas → Name Manager → delete the external name |
Data connection in xl/connections.xml | data_connection | Edit Links is for workbook links, not connections | Data → Queries & Connections → delete the connection |
| Cell hyperlink to another file | hyperlink | Hyperlinks don't appear in Edit Links at all | Right-click the cell → Remove Hyperlink |
Tool facts at a glance
What the auditor accepts and returns when you're chasing the prompt.
| Property | Value |
|---|---|
| Input | .xlsx only (re-save .xls / .xlsb first) |
| Output | Text report: Found N external link(s): + n. [type] url, or No external links found in this workbook. |
| Detected types | external_ref, hyperlink, data_connection |
| Modifies the file? | No — report only; you break links in Excel |
| Minimum tier | Pro (50 MB / 100,000 rows / 5 files) |
| Privacy | 100% in-browser via JSZip; no upload |
Cookbook
The recurring 'why does this keep prompting' situations, with the report text that explains each. File names anonymised.
Break Link said 'done' but the prompt still fires
A classic: the Edit Links dialog appears empty, yet the warning returns on every open. The auditor finds the leftover external_ref the dialog didn't clear.
Report: Found 1 external link(s): 1. [external_ref] file:///C:/Old/source-model.xlsx -> The externalLinks part survived. Re-run Break Link or delete the related defined name in Name Manager, then re-save.
The culprit is a data connection, not a link
Edit Links shows nothing because the prompt is driven by a connection. The audit makes the real cause obvious.
Report: Found 1 external link(s): 1. [data_connection] Data Source=\\server\share\reference.accdb -> Data > Queries & Connections > delete this connection.
Reference hiding in a defined name
No cell visibly uses the link, but a named range does. The external_ref appears in the audit; Name Manager is where you remove it.
Report: Found 1 external link(s): 1. [external_ref] file:///\\nas\rates\fx.xlsx -> Formulas > Name Manager > find the name resolving to [fx.xlsx] and delete it; re-save and re-audit.
Multiple leftovers from a copied template
Workbooks cloned from a template often inherit several external_ref parts. The audit lists each so you can clear them all in one session.
Report: Found 2 external link(s): 1. [external_ref] file:///C:/Templates/master.xlsx 2. [external_ref] file:///\\nas\templates\lookup.xlsx
Confirming the prompt is finally gone
After deleting the connection and breaking the links, the second pass returns the clean line that means the warning won't return.
Pass 2 (after cleanup): No external links found in this workbook. -> Reopen the file: no Update Links prompt.
Edge cases and what actually happens
Edit Links dialog is empty but the prompt still appears
Surfaced by the auditThe warning fires from the presence of external parts in the package, and Break Link doesn't always remove the underlying xl/externalLinks/ part — especially when a defined name still references it. The auditor reports the external_ref even when Edit Links shows nothing, telling you the part is still there. Delete the related defined name in Name Manager and re-save.
Reference lives only in a defined name, no cell uses it
Detected via the relationshipA named range pointing at [Other.xlsx] requires an externalLinks relationship, so the target shows as external_ref in the report even when Ctrl+F on the sheet finds nothing. Look in Formulas → Name Manager for the name whose scope/refers-to contains the file token, and delete it.
The report shows the path but not the cell or name
Not reportedThe inventory gives type and target, not location. To track it down, search formulas for the file token and check Name Manager and data-validation lists in Excel. The audit narrows the hunt to a specific target string; Excel's search tools find where it lives.
Data connection is the real cause
data_connection — often overlookedExcel's Edit Links dialog is only for workbook links, so a connection in xl/connections.xml can drive the prompt with nothing in Edit Links to clear. The auditor reports it as data_connection; remove it under Data → Queries & Connections.
Link rebuilt by a macro on open
Not detected at audit timeVBA that re-creates an external reference each time the workbook opens won't leave a static relationship part for the scan when the file is at rest, so the auditor can't see a link that only exists at runtime. If the prompt returns after a clean audit, suspect a macro — strip it with the VBA Macro Stripper.
Conditional formatting or data validation referencing another workbook
Detected only if relationship-backedExcel generally rejects external workbook references in conditional-formatting and data-validation rules, but where such a reference exists it is carried by an externalLinks relationship and so appears as external_ref. If the prompt persists with no report entry, the cause is elsewhere (a macro, or an image-anchored link).
.xlsb / .xls file
RejectedThese aren't OOXML ZIP containers, so JSZip can't unpack them and the prompt's source can't be scanned. Save as .xlsx in Excel, then audit the converted file.
Encrypted workbook
Cannot parseAn open-password-encrypted file is an encrypted container, not a readable ZIP — no scan runs. Remove the password in Excel, audit and clean, then re-apply protection if needed.
Hyperlink, not a workbook link, is what you noticed
Reported, but doesn't cause the promptCell hyperlinks are reported as hyperlink, but they do not trigger the 'Update Links?' prompt — only workbook references and connections do. If you only see hyperlink entries and the prompt still fires, the cause is a macro or a part outside the three scanned. Remove the hyperlinks for hygiene regardless.
Clean audit, prompt gone
ExpectedWhen the report returns No external links found in this workbook., the externalLinks and connections parts that fed the warning are gone, and reopening the file should no longer prompt. Save this report as proof the issue is resolved.
Frequently asked questions
Why does the 'Update Links?' popup persist after I broke all links?
Because the prompt fires from the existence of external parts in the package, and Data → Edit Links → Break Link doesn't always remove the underlying xl/externalLinks/ part — particularly when a defined name still references it, or when the real cause is a data connection that Edit Links never lists. The auditor reads those parts directly and reports the leftover reference so you can target it: delete the defined name in Name Manager and remove the connection, then re-save.
Can the tool break the links automatically?
No — it reports only. Removal happens in Excel: Break Link for workbook references, delete external defined names in Name Manager, and remove connections under Data → Queries & Connections. Then re-run the auditor to confirm a clean result, which means the prompt won't return.
Edit Links shows nothing — so where is the link?
Most often in a defined name or a data connection. A named range pointing at another workbook keeps an external_ref relationship alive even with no visible cell using it; a connection in xl/connections.xml drives the prompt with nothing for Edit Links to show. The audit reports both, with the exact target string to find in Name Manager or Queries & Connections.
I can't find the referenced cell from the report — what now?
The report gives the target path, not the cell. Copy the file token (e.g. [source.xlsx]) and use Excel's Ctrl+F across formulas, then check Formulas → Name Manager and data-validation lists. The reference is almost always in one of those. Delete it, save, and re-audit.
Could a data connection be causing the warning?
Yes, and it's a common blind spot. Excel's Edit Links dialog is only for workbook-to-workbook links, so a leftover ODBC/OLEDB/Power Query connection in xl/connections.xml can keep the prompt firing with nothing in Edit Links. The auditor reports it as data_connection; delete it under Data → Queries & Connections.
Will breaking the links lose my data?
No — Break Link converts each external reference to its last calculated value, so the numbers you see stay; only the live connection to the other workbook is severed. If you want to freeze all formula results to static values across the workbook in one pass, use the Formula to Value converter.
What does a clean audit result prove?
That the OOXML parts which feed the prompt — xl/externalLinks/ relationship targets and xl/connections.xml entries — are gone. With those removed, reopening the file should no longer show the 'Update Links?' warning. (Cell hyperlinks don't cause the prompt, so their presence or absence doesn't affect it.)
The prompt came back after a clean audit — why?
The most likely cause is a macro that rebuilds an external reference when the workbook opens; such a link doesn't exist as a static part for the scan to find at rest. Strip macros with the VBA Macro Stripper and re-test. Image- or shape-anchored hyperlinks (in the drawings parts) are also outside the scan's scope.
Is my workbook uploaded to audit it?
No. It's unpacked and scanned in your browser with JSZip; nothing is sent anywhere. Safe for confidential models you'd rather not upload.
Why was my file rejected?
It's likely not an .xlsx (legacy .xls and binary .xlsb aren't accepted — re-save as .xlsx), it's encrypted (remove the open-password first), or it's over your tier's size cap (50 MB on Pro, 500 MB on Developer).
Does it look inside hidden sheets for the link?
Yes for the parts it reads — hyperlink relationships are per-worksheet rels regardless of visibility, and externalLinks/connections.xml are workbook-level, so hidden and very-hidden sheets don't shield their references. To eliminate hidden sheets entirely, use the Hidden Sheet Destroyer.
How is this different from Excel's Edit Links dialog?
Edit Links shows only workbook references and frequently leaves the part behind after Break Link. This auditor reads the raw OOXML and reports workbook references, hyperlinks, and data connections together — including the leftovers and connections Edit Links never surfaces, which is usually why the prompt keeps coming back.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.