Video Find And Fix Circular References. Our inability to see the circular reference does not mean it is not there. To check your Excel workbook for circular references perform the following steps.
Find Circular Reference Dependent Formulas Using Trace Dependents Tool. The crc file tells you the order of the loop. Are an expense we would run into a circular reference problem.
The crc file gives you an idea of whats causing the circular reference but it doesnt tell you whats wrong.
Click on the cell listed under Circular References and Excel will bring you exactly to that cell. It just means the circular chain of references is much longer than we or even Excel can follow easily. To check your Excel workbook for circular references perform the following steps. If cell G2 is not the cause of the circular reference error click the next cell in the Circular References sub-menu as per screenshot above.