Fix your Excel formula errors — free.
Upload a spreadsheet and we’ll find every formula that’s broken or throwing an error —
#REF!, #DIV/0!, #VALUE!, #NAME?, #SPILL! —
tell you in plain English what each one means and the likely cause, and flag the ones that still
calculate a wrong answer. Nothing is changed without showing you first.
What these errors mean
Excel shows an error token in a cell when a formula can’t return a valid answer. The most common ones:
#REF!— the formula points at a cell, row, column, or sheet that was deleted or moved.#DIV/0!— it divides by zero, or by a cell that’s empty.#VALUE!— a value is the wrong type: text where a number is expected.#NAME?— an unrecognized name — a misspelled function or a named range that doesn’t exist.#SPILL!— a dynamic-array formula can’t expand because something is already in the cells it needs.#N/A— a lookup (VLOOKUP,XLOOKUP,MATCH) found no match.#NUM!,#NULL!,#CALC!— invalid numbers, non-intersecting ranges, or a calculation that can’t complete.
The silent-wrong ones
Not every bad formula shows an error token. Some calculate a number that’s simply wrong. We recalculate each formula with our own engine and flag any cell where the result differs from the value stored in the file — those are the ones worth a closer look even though Excel shows no error.
How it works
The page runs the same functions your AI agent would call through our tools: it locates every formula, recalculates each result with our own engine, compares it with the value stored in the file, and explains what it found. It reads your file in memory and never stores it — this check changes nothing, it only tells you what’s wrong.
Want this inside your AI agent, on your own machine, with no upload at all? Install xlsx-for-ai and ask Claude or Cursor to “find the broken formulas in this workbook.”
All Fix your Excel formula errors — free. guides
- Divide by zero error in Excel — how to hide it or show blank instead
- Excel circular reference warning keeps popping up (how to find and fix)
- Excel doesn't recognize my formula — #NAME? error
- Excel shows #### for a date — what does that mean?
- Excel stopped calculating automatically — formulas not updating
- FILTER function returns CALC error — no results found
- Formula gives a wrong number — Excel not calculating correctly
- Formula gives #REF! error when I copy it to another cell
- Formula shows 0 instead of the right answer — circular reference
- Formula shows #DIV/0! when the cell is empty (how to stop it)
- Green triangle in Excel cell — what does it mean?
- How to hide all formula errors in Excel (IFERROR / IFNA)
- INDEX MATCH returning N/A — how to fix
- Leading zeros disappeared — ZIP codes, SKUs, and phone numbers turned into shorter numbers
- My cell shows pound signs / hashtags instead of a number or date
- My Excel formula broke when I deleted a row (how to fix)
- My formula just shows the formula text, not the answer
- #NAME? error — formula worked before, now it doesn't
- #NUM! error in Excel — square root or math formula not working
- #NUM! error in IRR or NPV formula — what does it mean?
- #REF! error — what it means and how to fix it
- SPILL error in Excel — formula is blocking other cells
- SUM returns 0 — even though the cells have numbers in them
- #VALUE! error — what it means and how to fix it
- #VALUE! error when I paste data from another system or the web
- VLOOKUP returns #N/A — but the value is right there
- What does #### mean in Excel — and how do I fix it?
- What is a circular reference in Excel — and how do I fix it?
- What is the #CALC! error in Excel — and how do I fix it?
- What is the #DIV/0! error in Excel — and how do I fix it?
- What is the #N/A error in Excel — and how do I fix it?
- What is the #NAME? error in Excel — and how do I fix it?
- What is the #NULL! error in Excel — and how do I fix it?
- What is the #NUM! error in Excel — and how do I fix it?
- What is the #SPILL! error in Excel — and how do I fix it?
- XLOOKUP can't find a value that I can clearly see (how to fix)