How to find the source of excel's 'update links?' warning and remove it
- Step 1Upload the workbook showing the Update Links popup — Drop the .xlsx. JSZip unpacks and scans all XML relationship files.
- Step 2Review the full link inventory — Every external reference is listed, including any hidden in named ranges or defined name formulas.
- Step 3Break each reference in Excel — Navigate to each referenced cell or named range and break the link manually. Re-audit to confirm zero links remain.
Frequently asked questions
Why does the 'Update Links?' popup persist after I break all links?+
Links often hide in named ranges, data validation lists, or conditional formatting formulas that Data → Edit Links doesn't surface. The auditor finds these.
Can the tool break the links automatically?+
Audit only in the current version. Automated link-breaking with cached-value preservation is on the Pro roadmap.
What if I can't find the referenced cells from the audit report?+
Use Ctrl+F in Excel to search for the external path string (e.g. [OtherFile.xlsx]). This locates the exact cells.
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.