Categories
AcademyCircular references
Circular references
A circular reference in Excel indicates that the calculation in a certain cell refers to it’s own result once or several times. This is usually unintended.
What is a circular reference
A circular reference refers to a formula, that visits its own or another cell more than once in its chain of calculations, creating an infinite loop which slows down your spreadsheet significantly.
Iterative calculation, friend or foe?
Among the infinite number of settings in Excel, one innocent looking option fundamentally changes the way Excel calculates formula results. It goes by the name Iterative calculation.