Friction TamerExcel knows there are external links.
Now you can know exactly where.
Find external references across XLSX/XLSM workbooks, identify broken sources and missing targets, reveal the exact location, then repair only what you choose.
External references don't only live in cells.
Link Detective scans the Open XML package for references in the places that are easy to miss when a workbook simply reports “external links”.
Formulas & names
Cell formulas and defined names, with the source workbook and exact workbook location surfaced clearly.
Rules & validation
Conditional formatting and data-validation formulas that can quietly keep old workbook references alive.
Charts & package parts
Chart series and other supported Open XML locations that ordinary cell searches can overlook.
Know what's broken—and filter to only what matters.
OK
The target workbook can be resolved and the referenced sheet/target can be verified.
Broken
Separate missing source files from cases where the workbook exists but the referenced target no longer does.
Unverified
For paths that cannot be proven safely, locate the source manually or verify a whole folder without modifying the workbook.
Mass replacement when you want it. Surgical changes when you don't.
Replace a source workbook everywhere, retarget only selected findings to a new workbook/sheet/range, or break only the selected references. Multiple selection is supported.
Changes are deliberately conservative.
Backup first
A timestamped backup is created before a mutation is promoted to the original workbook.
Validate after
The edited package is validated and rescanned before the operation is treated as successful.
Refuse unsafe breaks
If a formula has no usable cached result, Link Detective refuses to break it instead of inventing a replacement value.
Diagnose free. Unlock repair for €14.99 once.
Free
For diagnosis, auditing and reports.
- ✓ Scan and list external references
- ✓ Health status + broken-only filters
- ✓ Reveal reference locations
- ✓ Locate source / verify folder
- ✓ Open target workbook
- ✓ Export report
Pro
One-time purchase · perpetual licence · up to 2 devices.
- ✓ Everything in Free
- ◆ Replace source
- ◆ Retarget selected reference(s)
- ◆ Pick target from spreadsheet
- ◆ Break selected reference(s)
- ◆ Repair workflow with backups