Skip to content
Formula Audit XL

Changelog

Release notes for Formula Audit XL. Every version is available for download from the download page.

v1.4.0

Model Check report and Cell Map improvements.

  • New Model Check (Ctrl+Shift+R) now lists Hidden and Very Hidden sheets by name in the summary scorecard.
  • New Cell Map (Ctrl+Shift+M) legend window now lets you edit and save your own colour palette.
  • Improved Explore Precedents tree now persists its expanded state when you step back and forward.
  • Improved Inconsistent Formulas (Ctrl+Shift+I) run time reduced by approximately 40% on large sheets (10,000+ cells).
  • Fix Fixed an edge case where array formulas using XLOOKUP were incorrectly flagged as hardcoded numbers.
  • Fix Ribbon buttons no longer grey out incorrectly after switching between workbooks.

v1.3.2

Stability fixes for Excel 365 build 16.0.17830.

  • Fix Fixed a crash on launch affecting some Excel 365 build 17830 (April 2026 channel) users on Windows 11.
  • Fix Model Check no longer stalls when the workbook contains a protected sheet.
  • Improved Improved error message clarity when a licence check fails due to a corporate proxy intercepting the TLS connection.

v1.3.0

Named Ranges audit and Explore Precedents drill-down.

  • New Named Ranges (Ctrl+Shift+J): audit every defined name, flag broken (#REF!), error and unused names, and delete obsolete names from the list.
  • New Explore Precedents (Ctrl+Q) gained a full drill-down tree: step into each input and back out, with the active cell highlighted.
  • Improved Result windows now share a consistent live filter box and ✗ / ⚠ / ✓ status icons.
  • Fix Circular reference detection (Ctrl+Shift+C) now correctly handles mutual references spanning more than three sheets.

v1.2.1

Minor fixes and Windows 11 high-DPI compatibility.

  • Fix Fixed add-in window rendering at 150% and 175% DPI scaling settings on Windows 11.
  • Fix Explore Dependents now correctly identifies dependents referenced via named ranges defined at workbook scope.
  • Improved Licence activation flow simplified: single-step activation from the ribbon replaces the previous two-step modal.

v1.2.0

Initial public release.

  • New Explore Precedents & Dependents: interactive tree across cells, sheets and workbooks (Ctrl+Q / Ctrl+Shift+Q).
  • New Model Check: one-click whole-workbook health report and scorecard (Ctrl+Shift+R).
  • New Cell Map + AutoColor: colour-code every cell by type, plus finance-standard font colours (Ctrl+Shift+M / Ctrl+Shift+U).
  • New Audit checks: circular references, errors, hardcoded numbers, dead cells, external links and inconsistent formulas, each one click away.
  • New Free web tools: circular-reference finder, external-link scanner and hardcode detector, all running in-browser.