How to fix Circular Reference error in Excel


Circular Reference error messages may appear sporadically in cells or when an Excel spreadsheet is opened. To find out the causes and how to fix Circular Reference errors in Excel, read along with the following article of Taimienphi.vn.


In the following article, Betdownload.com will guide you how to fix Circular Reference error in Excel. Also readers can refer to some other articles already on Taimienphi.vn to learn how to fix the #NAME error? and #REF! errors in Excel.

1. Circular Reference error in Excel

The Circular Reference error in Excel occurs when a formula in a cell references the same cell. For example, in the screenshot below, the formula in cell F7 is:

= F5 + F6 + F7

This will create a Circular Reference error because the formula entered in cell F7 refers to cell F7. This error will remove the results of the other formulas in cells D7, C11 and D11, respectively:

= F7 // formula in cell C7
= SUM (B7: C7) // the formula in cell D7
= SUM (C5: C9) // the formula in cell C11
= SUM (D5: D9) // the formula in cell D11

Circular Reference can be problematic and confusing because errors can cause other formulas to return 0 or an incorrect result.

2. Circular Reference error message

If the Circular Reference appears in the worksheet, you will see an error message like the following:

“There are one or more circular references where a formula educated to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing these references, or moving the formulas to different cells”.

how to fix circular reference in excel 2

This alert will appear sporadically while editing or the spreadsheet is open.

3. Find and fix circular reference errors in Excel

To make a circular reference error in Excel, we will first have to find the cells with incorrect cell references and adjust them as needed. However, unlike other errors like # N / A error or #VALUE !, error … in Excel, circular reference errors do not appear directly in the cell.

To find the source of the circular reference error, we will have to use it Error Checking menu in Formulas tab on the Ribbon.

how to fix circular reference in excel 3

Select the item Circular References To see the source of the circular reference error:

how to fix circular reference in excel 4

After the circular reference error is corrected, the formulas will return the correct results:

how to fix circular reference in excel 5

https://thuthuat.taimienphi.vn/cach-sua-loi-circular-reference-rong-excel-46560n.aspx
Above Taimienphi.vn has just taught you how to fix Circular Reference error in Excel. Hopefully the above article has provided you with useful information about errors as well as common error correction in Excel. In addition, if you have any questions or questions, you can leave your comments in the comment section below the article. fixes #### in Excel for example …

.

Add a Comment

Your email address will not be published. Required fields are marked *