Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

You get the error message about a circular reference when your formula is trying to calculate itself or includes a reference to itself. 

  1. On the Formulas tab, select the arrow next to  Error checking button Error Checking. 

  2. Select  Circular references button Circular References, and then choose the first cell listed in the submenu.

  3. Review the formula in the cell. If you can't determine whether the cell is the cause of the circular reference, select the next cell.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.