# 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.

Find #REF! and #DIV/0! errors, typed-in numbers, circular references and deleted links in an .xlsx or .xlsm file. No Excel needed.

- Tool: [Excel formula checker](https://fixmint.cc/excel-formula-checker)
- Category: [Spreadsheets & data](https://fixmint.cc/spreadsheets)
- Fixes: Workbook has broken formulas
- Runs in the browser: files and text stay on the device, no sign-up, free.

## How to find broken formulas in an Excel workbook

1. Drop your .xlsx or .xlsm file on the mat.
2. Read the findings, or filter them by kind.
3. 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.

## Related tools

- [Data type checker](https://fixmint.cc/data-type-checker): Column has mixed formats
- [CSV cleaner](https://fixmint.cc/csv-cleaner): Messy CSV with blanks and copies
- [Excel to CSV](https://fixmint.cc/excel-to-csv): Need CSV, have an Excel file
- [Anonymize spreadsheet](https://fixmint.cc/anonymize-spreadsheet): Names and emails in a table