#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.