Find broken and risky formulas in an Excel workbook
Drop a workbook to list its error results, typed-in numbers, loops and macros, with a trace for any cell.
- Runs on your device
- No sign-up
- Works offline after a visit
Values are the ones saved in the file. Nothing is recalculated.
How to find broken formulas in an Excel workbook
- Drop your .xlsx or .xlsm file on the mat.
- Read the findings, or filter them by kind.
- Pick a cell to see what it uses and what uses it.
Questions
Does it recalculate the workbook?
No. It reads the results Excel saved in the file, so a value is only as current as the last save. Formulas that were never calculated have no saved result and are not reported as errors.
Why is a number typed into a formula a risk?
A number such as 1.2 in =B2*1.2 is hidden from the reader and does not show up when you look for it. Zero, one, 100 and the digit argument of ROUND are not counted.
Is my workbook uploaded?
No. Your browser opens the file and nothing leaves the page. Macros are detected but never run.
What is a circular reference?
A chain of formulas that leads back to itself, such as A1 = B1 and B1 = A1. Excel warns about such loops, and the cells can show stale values. The check follows references within the book and ranges of up to 10,000 cells.
Reviews
No reviews yet. Be the first.