#REF! error

Excel glossary definition

A formula refers to a cell that no longer exists.

Definition

Usually appears after deleting rows, columns, or sheets that a formula was pointing to. Undo the deletion or rebuild the reference.

Back to Excel glossary