How To Find Circular Reference In Excel. This command displays a list of all cells that are involved in the circular reference in Excel. Our sheet contains 2 circular references.
Actually you can find out and locate the cell with circular reference in Excel with following steps. Click one to jump to that cell. Because the circular reference cannot calculate itself clicking OK on the warning would give you a result of 0.
Click on the cell listed under Circular References and Excel will bring you exactly to that cell.
A circular reference occurs in Excel when a formula contains a cell reference for a cell that contains the formula. Information in this article refers to versions. If the Formula Auditing group is collapsed as shown in figure 18 then click on it. Activate the worksheet that has the circular reference Click the Formulas tab In the Formula Editing group click on the Error Checking drop-down icon little downward pointing arrow at the right.