Excel #SPILL! error: what it means and how to fix it
Why a dynamic array formula can't spill its results, and how to clear the way.
The message you see
#SPILL!Fastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- Cells in the spill range already contain values, spaces or formulas.
- The spill range includes merged cells.
- The formula is inside an Excel Table, where spilling isn't allowed.
- A whole-column reference (A:A) makes the result too large.
How to fix it
- 1Click the error and choose “Select Obstructing Cells”, then clear them.
- 2Unmerge cells below or to the right of the formula.
- 3Convert the Table to a normal range, or move the formula outside it.
- 4Limit references to the actual data range (A2:A500 instead of A:A).
Related guides
Excel
“Excel cannot open the file because the file format or file extension is not valid”
ExcelExcel error “SYLK: File format is not valid” when opening a CSV
Excel“We found a problem with some content” — Excel workbook won't open properly
Still stuck? Ask SheetFix Support