If there are multiple circular references, then you are required to manually go to each cell & correct the formula until the status bar no longer shows the word “CIRCULAR REFERENCES”.Select Circular References & it will provide the location of the cell in which circular reference occurs.In Formula Auditing group, click on Error Checking.To track circular reference, follow the below steps: You can track & then remove the incorrect reference & it will remove the circular reference. If above shown error message regarding circular reference pops up while adding formulas, then you might have created circular cell reference unknowingly. While typing the sum formula, the range is stretched to cell A3 in which formula is entered.In cell A1 & A2, numbers are entered & in cell A3 we want to find out the total.It might cause the incorrect calculation by the formulas.
In simple words, the cell in which formula is being calculated & the cell itself is also included or part of the range then a circular reference warning message will appear. In this article, we will learn about circular reference.Ĭircular reference can be a formula that refers to its own cell value, or refers to a cell dependent on its own cell value.
