Interactive Excel error lab.
Pick #REF!, #VALUE!, #DIV/0!, #SPILL!, or #CALC!. Inspect the broken sheet, copy the fix, then send the example to the formula fixer.
| 1 | |||
|---|---|---|---|
| 2 | |||
| 3 | |||
| 4 | |||
| 5 |
#SPILL!
UNIQUE blocked by a leftover note
#SPILL! means a dynamic array cannot write into its output area. The UNIQUE formula is valid. Cell B3 still holds a leftover note, so Excel cannot spill the unique names.
Sample broken formula
=UNIQUE(A2:A5)Paste-ready fix
=UNIQUE(A2:A5)Keep the same formula. Clear every cell in the intended spill range, or move UNIQUE to an empty column outside a Table.
The fixer opens with this broken formula, #SPILL!, and the expected result already filled in. Open this station.
Five errors, one worksheet
The written error guides stay in place for search and deep reading. Use this lab when you want a sample you can click, copy, and hand to the fixer.
Error lab FAQ
How is the error lab different from the Excel error guides?
The guides explain each error in writing. The lab is a worksheet you can click: a broken sample, a paste-ready fix, and a button that loads that example into the formula fixer.
Which Excel errors can I load into the fixer?
The lab covers #REF!, #VALUE!, #DIV/0!, #SPILL!, and #CALC!. Each station sends the broken formula, the exact error, and the expected result.
Does sending an example run the fixer automatically?
No. The formula fixer opens already filled in. Review the fields, then submit when you want a correction.