identify cells with circular reference in Excel
Q108. In Excel, how can I identify cells with Circular Reference in a WorkSheet?
For example, I notice that Excel is displaying "Circular References" in the bottom left of the Active Window. In Excel, how do I identify the exact cell (which cell in which Sheet) with Circular Reference so that I can fix the problem?
To do it in Excel, here is the answer:
a) Click on "Error Checking" under "Formulas". Click on "Circular References". The exact cell that has a circular reference is listed (cell "BI3" in Sheet "Sales_Data" in this case).
b) If there is a circular reference in the ActiveSheet, Excel displays the exact cell in bottom left of the Active Window.
As shown below, when "Sales_Data" is the ActiveSheet, the cell with circular reference is indicated at bottom left.