Question: there is one or more circular references where a formula refers to its own cell?
Answer: Locating Circular References. A circular reference occurs when a formula directly or indirectly refers to its own cell. ... By default, Excel stops calculating after 100 iterations or after all values in the circular reference change by less than 0.001 between iterations, unless you change the Excel option.