Skip to content
Formula Audit XL

Excel formula auditing add-in

Audit any Excel model with confidence.

Trace formula logic, surface hidden errors, and x-ray an entire workbook in minutes, right inside Excel.

For Microsoft Excel on Windows: 2016, 2019, 2021 & 365 · No data leaves your machine

Q4-model-final-v7.xlsx
A
B
C
D
E
1
2
=B2*1.2
3
4
=B2*1.2
5
=[1]!A4
6
2 hardcodes 1 external link Traced

Used by analysts in banking, private equity, Big-4 audit & corporate finance

  • Investment Banking
  • Private Equity
  • FP&A
  • Big-4 Audit
  • Consulting
  • Corporate Finance

The problem

Every model hides a landmine.

Native Excel can find these, but slowly: one cell and one sheet at a time. On a real model, that’s how errors slip through.

Broken precedents you can’t see

A mistyped reference still returns a number. Native tracing checks one cell, on one sheet, at a time.

External links that silently change numbers

A link to a file you forgot about updates your model overnight. Edit Links misses links hidden in names, charts and validation.

Hardcodes buried in formulas

A magic number pasted into a formula breaks every scenario downstream, and nothing flags it.

What it does

Four ways to trust your model.

Explore precedents & dependents

Open an interactive drill-down tree of everything that feeds (or depends on) the active cell, across sheets, ranges and named ranges (Ctrl+Q / Ctrl+Shift+Q).

  • Interactive, step-into tree
  • Finds range & named-range dependents
  • Understand any formula instantly
Learn more

Model Check

One click produces a full-workbook health report: a per-sheet detail table plus a scorecard of errors, circular refs, broken links, hardcodes, dead cells and more (Ctrl+Shift+R).

  • Whole-workbook x-ray
  • Counts 10+ risk categories
  • Lists hidden & very-hidden sheets
Learn more

Cell Map

Colour-code every cell by type (inputs, formulas, cross-sheet and external references, hardcodes) to see a model's structure at a glance. Reversible in one click (Ctrl+Shift+M).

  • Colour by cell type
  • Editable legend
  • Plus AutoColor font conventions
Learn more

Inconsistent Formulas

Scans the sheet and lists cells whose formula breaks the row/column pattern of their neighbours (the classic overtyped mistake), tuned to keep noise low (Ctrl+Shift+I).

  • R1C1 pattern comparison
  • Ignores legitimate exceptions
  • Catch one broken cell in a copied range
Learn more

Better than built-in

Formula Audit XL vs native Excel auditing

Excel’s built-in Formula Auditing tools are fine for one cell. Formula Audit XL works across the whole model.

Capability Formula Audit XL Native Excel
Whole-workbook health report no
Explore precedents/dependents as a tree One-cell trace arrows
Finds dependents via ranges & named ranges no
Detect inconsistent (overtyped) formulas Per-cell warning only
Audit every defined name no
Colour-code cells by type no
Jump straight to the cell from a result list no

Not ready to install?

Try the free Circular Reference, External-Link & Hardcode Finder. Runs in your browser, nothing uploaded.

Try the free tool

Pricing

Simple pricing for serious modellers.

Free

€0 forever

The web tools + a limited add-in tier to try the core.

Download free
  • Free web tools (circular-ref, link & hardcode finder)
  • Read-only precedent / dependent tracing in Excel
  • Capped model size
  • Community support

Individual

€49 per year

The full auditing toolkit for one analyst.

Start

Prefer a one-time licence? Get lifetime for €129.

  • Everything in Free
  • Explore Precedents & Dependents (full tree)
  • Model Check: whole-workbook health report
  • Cell Map + AutoColor
  • Inconsistent-formula, named-range & error checks
  • Email support
Most popular

Team

€15 per seat / month, billed annually

For finance teams who review each other’s models.

Start a team trial

Volume pricing for 10+ seats. Contact us.

  • Everything in Individual
  • Multi-seat licence & admin console
  • Shared audit standards
  • Priority support & onboarding
  • Invoicing & VAT handling

Compare all features →

Stop eyeballing models. Start auditing them.

For Microsoft Excel on Windows: 2016, 2019, 2021 & 365 · No data leaves your machine