How to Find Circular References in Excel

If you by mistake refer to own cell or refer to a cell dependent on own cell in your formula you will face with this problem.

How to Find Circular References in Excel;

we have two kind of mistake

Refer to Own Cell Problem

for that you should follow these steps;

1- Click on the Formula tab.

2- Click on the Error Checking.

3- Click on the Circular References.

Here you can find the addrese of the cell which has problem.

Refer to a Cell Dependent on Own Cell Problem

For finding this kind of problem you should follow these steps;

1- Click on the Formula tab.

2- Click on the Error Checking.

3- Click on the Circular References.

Here you can find the addreses of the cells which have this problem.

How to Solve Circular References Problem in Excel;

1- Click on the File tab.

2- Select Options.

3- In the Right side of menu, click on the Formula.

4- Enable iterative calculation box.

5- Click Ok.

Now you can see the problem was solved.