Iterative calculation — Excel's "Enable iterative calculation" with its two limits.
Remarks
With it off a reference cycle evaluates to 0 and is reported as unresolved. With it on the
cells of the cycle are re-evaluated in turn, each read seeing the latest value, until no cell
moved by maxChange or maxIteration sweeps ran — and the results persist into
the next recalculation, which re-runs every cycle the way it re-runs NOW(): =A1+1 in A1 is
a counter that advances by maxIteration per recalc. A cycle that stops on the sweep cap is
still reported (ICircularReference.isConverged); a converged one is not.
Office Scripts calls the count maxIteration; the file format iterateCount / iterateDelta.
Iterative calculation — Excel's "Enable iterative calculation" with its two limits.
Remarks
With it off a reference cycle evaluates to
0and is reported as unresolved. With it on the cells of the cycle are re-evaluated in turn, each read seeing the latest value, until no cell moved by maxChange or maxIteration sweeps ran — and the results persist into the next recalculation, which re-runs every cycle the way it re-runsNOW():=A1+1in A1 is a counter that advances bymaxIterationper recalc. A cycle that stops on the sweep cap is still reported (ICircularReference.isConverged); a converged one is not.Office Scripts calls the count
maxIteration; the file formatiterateCount/iterateDelta.