How to audit and remove broken external references before client delivery
- Step 1Upload the workbook for delivery review — Drop the .xlsx. JSZip unpacks the container and scans all relationship and connection XML files.
- Step 2Review the link inventory — Every external reference is listed with its type and target path. Internal network paths are immediately visible.
- Step 3Break links in Excel, then re-audit — Use Excel's Data → Edit Links → Break Link to sever externals, then re-run the auditor to confirm a clean result.
Frequently asked questions
Can the tool automatically break the external links?+
Audit only in the current version. Auto-breaking while preserving cached values is on the Pro roadmap.
What does it mean if the report shows zero links?+
The workbook is self-contained. All values are embedded; no external sources are referenced.
Will it detect Power Query connections to web APIs?+
Power Query connections in xl/connections.xml are detected. The full M query text is not yet parsed.
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.