Circular reference

Excel glossary definition

A formula that refers, directly or indirectly, to its own cell.

Definition

Excel cannot resolve a formula that depends on its own result and shows a warning. Sometimes used intentionally with iterative calculation enabled, but usually a sign of a mistake in references.

Back to Excel glossary