In Excel, Circular reference warning is received withÂ *raised eyebrows and terrified looks most of the time*. But from our experience, we know it to be all smoke and no fire, which we will prove to you right here. So what really is a circular reference? It simply means thatÂ ** your formula includes a cell which is covered by the formula**. A simple example is as below: Circular reference work in excel 2006, excel 2007, excel 2010, excel 2013

In the above cells, you can see that the **formula calculates** a sum in cell D15 but the formula includes D15 in its range.

**What is Find Circular Reference in Excel?**

**Circular Reference Warning:**

Once you create a circular reference, a warning box appears where you can either seek help for correcting formula or click ok to accept the reference. If you do press Ok, the cell will display â€ś-â€ś or â€ś0â€ť as below.

Say, you decide to select help from the dialogue box. Then the following help box or search term will appear giving you various tips to correct your formula.

**How to find a circular reference on your Excel sheet:**

Steps toÂ __find a circular reference in Excel__

- Click On Menu bar, Click on Formulas
- Select Error Checking and a drop-down list will unfold.
- Click on Circular References from the drop-down list and it will give out the cell which has circular references

This will find excel function and remove circular references.

This way you can review all the formulas shown in cells in the sub-menu and correct them one by one.

**Fix Circular Reference warning by enabling iterative calculation:**

ToÂ __ fix circular reference warning in your excel worksheet,__Â you need to enable Iterative calculation. It is not enabled by default because the iterative calculation affects and slows down your machineâ€™s performance.

- Go to File and select options from the drop-down list.
- A dialogue box will appear; select Formulas.
- Check the
**Enable Iterative Calculation**option under Calculation Options menu. - You can also
**specify the maximum number of time**the system needs to go on calculating the iteration. By default, it is on 100.

**Using Circular Reference in Excel for your benefit:**

So you must be thinking thatÂ **circular references are useless**Â and your goal is to find the circular reference and fix it. Youâ€™re wrong!. There are formulas and equations that might need you to create a circular reference. Let me take you through one example. Also, You can check our Online Free Excel, PowerPoint & VBA Tips. You are constructing a building and you have decided to give 2% commission on total building cost to your builder. Simpleâ€¦.right? Not if the 2% includes the cost of builderâ€™s fee!Â If you want to do it using a formula, you can do it. But imagine having hundreds of suchÂ **factors and iterations**. Just follow simple steps as below: *Put in the formula for the total cost which includes cell C3.*

Next, against the commission, enter the formula as given below which will create a circular reference and the tracer arrow will show it. As far as the circular reference warning box is concerned just click on ok.

**Read More: How to add APA Page Numbers in Microsoft Word**

**enabling iterative calculations** as shown in point 4 above. OnceÂ done, you will get the right calculation as below, Problem solved! *Is there another way you find circular reference useful? Share your views here!*

**Some Related Searches on Circular Reference:**

how to find circular reference in excel |

find circular reference |

excel find circular reference |

how to find circular reference |

circular reference in excel |

find circular reference excel |

find circular reference in excel |

how to find a circular reference |

how to find circular references in excel |

how to find a circular reference in excel |