Audit a workbook's formulas
In the middle of a column of totals, a cell where someone typed 999 instead of the formula. Elsewhere, a formula that multiplies by 1.2 when its neighbours do not. Every formula in the workbook is read and what stands out is listed, cell by cell.
What this tool does
- Formulas that return an error (#N/A, #REF!, #DIV/0!, #VALUE!), with their formula.
- Hard-coded values in the middle of a column of formulas, and formulas that differ from both neighbours.
- Direct circular references, formulas that read another workbook, volatile functions (INDIRECT, OFFSET, NOW) that slow the file down.
- A workbook report: each finding with its sheet, cell and formula.
What it does not do: Formulas are read, not recalculated: the audit points to what deserves a look, it does not say a result is wrong. A circular reference that goes through several cells is not followed.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.
- Clean before sending : Author, comments, hidden sheets, macros: what travels with the file without showing.
- Inspect a workbook : Hidden sheets, author, comments, links: what the file carries without showing it.
- Slim down a workbook : Phantom rows, thousands of styles, copied formatting: the extra weight, removed.
- Formulas to values : Paste Special, Values, on the whole workbook at once: the file is frozen.