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

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 about Explore precedents & dependents

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 about Model Check

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 about Cell Map

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 about Inconsistent Formulas

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 trial

$0 for 7 days

The browser web tools, plus a 7-day full trial of the add-in.

Start free trial (Free trial plan)
  • Free web tools (circular-ref, link & hardcode finder)
  • 7-day add-in trial with every feature unlocked
  • No credit card needed to start
  • Community support
Most popular

Yearly

$3 /mo, billed yearly

The full auditing toolkit — just $3/month, billed once a year.

Get Yearly (Yearly plan) Or buy Lifetime for $129

That’s $36 billed once a year ($3/mo). Cancel anytime from your account.

  • Every feature unlocked while subscribed
  • Explore Precedents & Dependents (full tree)
  • Model Check: whole-workbook health report
  • Cell Map + AutoColor
  • Inconsistent-formula, named-range & error checks
  • Manage your card & cancel anytime at /account
  • Email support

Lifetime

$129 one-time

Own the add-in as it is today. One payment, no renewals.

Buy Lifetime (Lifetime plan)

One-time payment for the add-in as-is. 30-day money-back guarantee. Updates are not guaranteed for life.

  • Everything in Yearly, kept for good
  • No recurring billing — ever
  • The add-in as it is today, yours to keep
  • Updates included while we ship them (not guaranteed for life)
  • Priority email support

Compare all features →

Stop eyeballing models. Start auditing them.

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