Forum Discussion
Mel Ingalls
Jul 03, 2017Copper Contributor
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