You are working with your spreadsheet and all of a sudden, you get following error –
To know where is the problem, click OK on this.
Go to Formulas > Error Checking > Circular Reference
This will list a problem. Work on this problem cell and remove circular reference. If there are more problem cells, Circular References will list a cell. Keep removing till Circular References doesn't have any cell listed. Key thing to remember is that it will not list all cells in one go but will list only one problem cell.
There are Circular References problem cells can also be visually located by looking at the bottom left of the Sheet. When sheet contains, 0 Circular References, then this will not appear.
