counting iterations

[Mitch]

I have inherited a workbook that uses an iterative approach to resolve
circular references. I need to record the number of iterations used to
resolve the circular reference, but I cannot find a VBA method/property/etc.
that can report the number of iterations used. It must be in there
somewhere! Can anyone help me?

 

[Charles Williams]

I think you need to use a calculation counter: you can download
CalcTrace.zip from my downloads page
http://www.DecisionModels.com/downloads.htm

You would need to use the CalcSeqCountRef function referring to one of the
cells in the circular reference loop.
Note that the number of calculations reported should be 1 larger than the
number of iterations.

You may also find it useful to read the description of how excel performs
circular reference calculations at
http://www.decisionmodels.com/calcsecretsc.htm

and some comments on circular references at
http://www.decisionmodels.com/calcsecretsk.htm


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

 

[Tom Ogilvy]

Excel doesn't report that. You can see the maximum allowed in
Tools=>References, Calculation tab.