#REF! error in Excel
A #REF! error appears when a formula refers to a cell or range that has been deleted or moved, so the reference itself can no longer be resolved.
Deleting a column that a formula depended on turns the reference into an error, and copying that formula spreads it.
Fixing it means reconstructing which range was intended, which is why a review should record the error before anyone edits the model.
More definitions
Twenty-five terms a reviewer needs, each in one sentence followed by the context that matters.