How to audit a financial model in Excel

Native steps checked against Microsoft Support on 16 November 2026 · updated 16 November 2026

To audit a financial model in Excel, use the Inquire tab: Workbook Analysis reports formulas, cells, ranges and warnings for the whole workbook. Then check hardcoded constants with Go To Special and trace the key totals with Trace Precedents. The findings still need a reviewer's judgement.

The native Excel method

  1. Turn on the Inquire add-in if the tab is not on the Ribbon.
  2. Select the Inquire tab, then Workbook Analysis.
  3. In the Items box, choose what to analyse: summary, workbook, formulas, cells, ranges and warnings.
  4. Select the first range from the report and press Ctrl+G, then Special, to check it for hardcoded constants.
  5. Trace the key totals with Trace Precedents and Trace Dependents to confirm the chain reaches the inputs.

What Workbook Analysis gives you

Microsoft describes Workbook Analysis as an interactive report covering the workbook’s summary, formulas, cells, ranges and warnings, built from the items you tick in the Items box (Microsoft Support).

It is the closest thing Excel has to a structured audit out of the box, and the warnings section is the part most reviewers read first.

What it does not do

The report describes the workbook; it does not rank the findings or tell you which ones matter. A list of every cell in the model is not a review. Sorting a hundred warnings into the three that could change a conclusion is the work, and Inquire leaves it to you.

The Inquire add-in also has to be available in your edition, and it is not in every one.

A practical order for the manual audit

Start with the flags that are cheap to check and expensive to miss: hardcoded numbers inside calculation blocks, totals whose range stops short, error values, and formulas that nothing reads. Then trace the three or four totals the decision actually rests on, and confirm each chain ends at an input rather than a typed number.

The CalcoraSuite way (planned)

The planned audit produces a findings list — cell, reason, neighbouring pattern — that can be exported and re-run after fixes, rather than a report about the workbook. The model audit page carries its status.

The CalcoraSuite way

Planned, not released. The model audit page carries the current status of each step (planned).

  1. Run the audit over the workbook, or one sheet when time is short.
  2. Read the findings grouped by sheet: broken formulas, hardcoded inputs, ranges that stop short, unreferenced cells.
  3. Take the list into a review note, fix the model, then re-run.

Sources

Every native step above was checked against these Microsoft pages on 16 November 2026.

Get the add-in before release

Early access testers get each add-in first, with a short list of what to try.