Forum Discussion

Mel Ingalls's avatar
Mel Ingalls
Copper Contributor
Jul 03, 2017

Iteration and circular references

I have a cell that indirectly creates a circular reference, which I want. In reading the instructions for iteration, it would appear that the iteration continues until the cell with the circular reference stops changing by at least the threshhold (typically .001 as a threshhold and a max of 100 iterations). The cell that is likely to change as a result of each iteration is NOT the cell with the circular reference. Based on what I am seeing, Excel 360 is not iterating until ALL cells stop changing, which is what I want. It appears to be looking only at the cell with the circular reference.

 

Does anyone know how I can get Excel 360 to keep iterating until ALL cells in the workbook stop changing by at least the thresshold?

No RepliesBe the first to reply

Resources