#REF!
A formula points at a cell that no longer exists.
What it means
The reference itself is gone: the row, column or sheet it addressed was deleted. Unlike a wrong value, the formula text is now permanently broken and must be repointed.
How to fix it
- Undo the delete, then move the formula or its data first.
- Repoint the reference at the surviving cells.
- In deepcalc, read the journal diff to see exactly which structural edit broke it; every rewrite is recorded as an op.
Common causes
- Deleting a row, column or worksheet a formula referenced.
- A lookup asked for a column index outside the given range.
- Cutting and pasting over cells another formula depended on.