This is the help in office. You can have a look,
Allow, cancel or correct circular references
Show all
Hide all
If the formula
(Formula: A series of values, cell references, names or operator combinations in a cell can generate a new value. Formulas always use an equal sign.
(=)
Here we go. ) refers to the cell where you are, whether it is a direct reference or an indirect reference, it is called a circular reference. As long as one of the open workbooks contains circular references, microsoft
office
be good at
You will not be able to automatically calculate all open workbooks. At this point, you can cancel the circular reference or let
be good at
Use previous iterations
(Iteration: Calculate the worksheet repeatedly until certain numerical conditions are met. The calculation result is calculated once for each cell involved in the circular reference. Unless you change the default iteration settings, excel
Will be at
100
The difference between all values in the circular reference after iteration or between two adjacent iterations is less than
0.00 1
When (whichever iteration comes first), stop the operation.
what do you want to do?
-
Locating and canceling circular references
change
be good at
The number of iterations of the formula makes the circular reference work.
-
Locating and canceling circular references
On the Formula tab, in the Formula Auditing group, click the arrow on the button in the Error Checking group, point to Circular Reference, and then click the first cell listed in the submenu.
point out
Double-click the tracking arrow to move between the cells involved in the circular reference.
Check the formula in the cell. If you are not sure whether the circular reference is caused by this cell, click the next cell in the Circular Reference submenu.
To annotate ...
Immediately after the word "loop" in the status bar, a reference to a cell in the loop reference is displayed. If there is no cell reference after the word "cycle", there is no cycle reference in active sheet.
Continue to check and correct circular references until the word "circular" no longer appears in the status bar.
Return to the peak
change
be good at
The number of iterations of the formula makes the circular reference work.
Click microsoft.
office
Button, click excel.
Option, and then click the formula category.
In the Calculation Options section, select the Enable Iterative Calculation check box.
set up
be good at
For the maximum number of recalculations, type the number of iterations in the Maximum number of iterations box. The higher the number of iterations, excel
The longer it takes to calculate the worksheet.
To set the maximum acceptable error between two calculation results, type the required value in the Maximum Error box. The smaller the value, the more accurate the result. be good at
The longer it takes to calculate the worksheet.