Feature
Five targeted checks. Every major model risk, covered.
Tracking down errors, circulars, and broken links across a multi-sheet workbook is slow, error-prone, and easy to skip under deadline pressure.
What Formula Audit XL does
One-click checks for circular references, errors, hardcoded numbers, dead cells, and external links, each with a filterable results list and direct cell navigation.
The problem with doing this in native Excel
- Excel's circular reference indicator shows only one circular at a time with no list
- Error checking is sheet-by-sheet with no cross-workbook summary
- There is no native tool to find hardcoded numbers inside formulas or cells nothing references
How Formula Audit XL does it
- 1 Pick the check you need. Run any check from the Formula Audit XL ribbon or with its shortcut: Circular References (Ctrl+Shift+C), Error Checker (Ctrl+Shift+E), Hardcoded Numbers (Ctrl+Shift+H), Dead Cells (Ctrl+Shift+D), or External Links (Ctrl+Shift+L).
- 2 Filter and navigate the results. Every results window has a live filter box and status icons (✗ for errors, ⚠ for warnings, ✓ for clean). Click or use arrow keys to jump directly to any flagged cell.
- 3 Fix or remove issues. For External Links, select individual links to break or use Break All to remove every external reference in one step.
Who needs this most
- Auditors doing a pre-delivery model review
- Finance teams cleaning up models before distribution
- Controllers checking for data-entry errors
- Analysts diagnosing unexpected calculation results
The Audit Checks suite gives you five focused diagnostics, each reachable with a single keyboard shortcut. Run them individually during model development, or work through all five as a pre-delivery checklist.
Every results window is designed for speed: a live filter narrows the list as you type, status icons give an instant severity read, and keyboard navigation means you never have to take your hands off the keyboard to move between findings.
Frequently asked questions
What does Circular References check find?
Every circular dependency chain across all sheets, listed with the cells involved so you can resolve each one directly.
Which error values does Error Checker catch?
#REF!, #DIV/0!, #VALUE!, #N/A, and all other Excel error values, across every sheet in the workbook.
What counts as a hardcoded number?
Any numeric constant typed directly inside a formula (e.g. =A1*1.2) rather than referenced from an input cell. These are often unintentional hard-codes that should live in a named input.
What is a dead cell?
A cell that contains a value or formula but is not referenced by any other cell in the workbook. It may be clutter or a sign that a formula chain is broken.
Stop eyeballing models. Start auditing them.
For Microsoft Excel on Windows: 2016, 2019, 2021 & 365 · No data leaves your machine