DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to fix a circular reference error In Excel Office 365? – [With Example]

In this blog post, you will learn what is Circular Reference Error In Excel Office 365? Why it occurs, and how to fix it. Let’s get into this post and see them one by one. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Circular Reference Error – Causes

  • This errors occur when a formula refers back to its own cell.
  • When a workbook contains a circular reference , Excel cannot automatically perform calculations.

Practical Example

  • For example, you have created a sample data with list of values in Excel.

Sample data

  • Then, you need to use the below-given formula in cell F7.
=F5+F6+F7

Enter fullscreen mode Exit fullscreen mode

Use the Formula

  • Now, it creates a circular reference because the formula, entered in cell F7 , refers to F7 and in turn throws off other formula results in D7, C11, and D11.

Error Output

How To Fix It?

  • To resolve circular references, you need to find the cells with incorrect cell references and adjust as needed.
  • The circular references error don’t appear directly in the cell as like other errors (#N/A, #VALUE!, etc.).
  • Then, to find the source of a circular reference error , you have to use the Error Checking menu on the Formulas tab of the ribbon.

Click on the Error Checking menu

  • Now, you need to select the Circular References item to see the source of circular references.

Select the Circular References item

  • Finally, the circular reference error has been fixed and other formulas now return correct results.

Error Fixed Output

Verdict

In this short article, you can understand what is Circular Reference Error In Excel Office 365? And how to fix it with example. Drop your queries/suggestions in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

Keep Reading:

Top comments (0)