Forum Discussion
Circular Reference get the Current Iteration value and number of iterations to converge
I have a spreadsheet that is using a circular reference to solve a thermodynamics problem under varying conditions. 99.9% of the time, it converges to the solution relatively quickly. However, for ...
Depending on how complex your calculations are it may be possible with a recursive Lambda (Limit is about 2,000 iterations which decreases with the number of parameters in the function.).
I was not clear on the complexity. It is a workbook with 40+ sheets containing 100+ circular reference circles, most of these spanning many sheets and intermingled and are not alike. (Yes, Excel handles this surprisingly well).
So my issue is not a question of handling a large number of simple iterations in a handful of circles that are feasible to track individually.(But your solutions may well be sufficient for Matt and others, so thanks anyway :-))
