How To Find A Circular Reference In Excel?

Go to the Formulas tab

Click Error Checking

Select Circular References

Click the listed cell address to jump to it

Check the formula in that cell

Trace precedents and dependents to find the loop

Repeat for any other cells listed under Circular References

Use Evaluate Formula if needed to inspect the calculation chain

Remove or change the reference causing the loop

Suggested for You

Trending Today