Check Your Spreadsheet for Formula Errors — Free Online Scanner

Why Formula Errors Are Dangerous

Research consistently shows that 94% of non-trivial spreadsheets contain at least one error. Many of those errors live quietly in formula logic, producing wrong numbers without any obvious sign that something is wrong.

Some errors are visible: a cell showing #REF! or #VALUE! signals a problem immediately. But others are invisible. A circular reference with iterative calculation enabled produces a number that looks valid. A broken external link shows the last cached value — potentially figures from months ago — with no indication they're stale.

The documented consequences of spreadsheet errors are severe. JPMorgan Chase's 2012 "London Whale" trading loss, estimated at $6 billion, was partly attributed to errors in a VaR model built in Excel. Fidelity's Magellan Fund miscalculated a capital gains distribution by $2.6 billion due to a sign error in a spreadsheet. These aren't anomalies — they're what happens when large, complex spreadsheets aren't systematically checked.

Every Error Type We Detect

A single upload scans your entire workbook for all of the following:

• #REF! errors — Broken cell references caused by deleted rows, columns, or moved cells
• Circular references — Formulas that reference their own cell directly or through a chain
• #VALUE! errors — Type mismatches where a formula receives the wrong kind of data
• #DIV/0! errors — Division by zero or empty cell in a denominator
• #NAME? errors — Unrecognized function names, typos, or undefined named ranges
• Broken external links — References to workbooks that have been moved, renamed, or deleted
• Volatile functions — NOW, TODAY, RAND, INDIRECT, OFFSET — functions that change results on every recalculation

How We Compare to Manual Checking and Excel's Built-in Tools

Excel's Formula Auditing tools — Trace Precedents, Error Checking, Evaluate Formula — are designed for cell-by-cell investigation. They're useful when you know where the problem is. They're not designed to find problems in a workbook you've never seen before, or to confirm that a 50-sheet model is error-free before you send it to a client.

When to Use the Formula Error Checker

The most common scenarios where a formula scan pays for itself in minutes:

• Before sending to a client — A visible formula error in your deliverable undermines confidence in the entire analysis
• Before a board or committee meeting — Volatile functions can change figures between your last review and the moment you open the file in the room
• During financial model review — Circular references and broken external links are common in inherited models and easy to miss manually
• After inheriting someone else's spreadsheet — You can't know what's in there without checking

How It Works

Upload your .xlsx or .xlsm file. The analysis engine reads every formula across every sheet, maps dependencies, and identifies error values, circular chains, broken references, and structural issues. You receive a 0–100 risk score and a complete issue list with exact cell locations within 30 seconds. Fix the issues, re-upload to verify, and optionally generate a PDF report for your records.