I use a spreadsheet with indirect circular cell references. When it works I
observe the iterations narrowing until I have a verifiable answer. However,
the iterations often expand (rather than narrow) leading to errors.
Is there anywhere I can read-up on iterative calculations in Excel?

I don't have experience with it myself, but would have thought that the
'Watch' function does what you want? Tools/Formula Auditing/Show Watch window.


"petersampson" wrote:

I use a spreadsheet with indirect circular cell references. When it works I
observe the iterations narrowing until I have a verifiable answer. However,
the iterations often expand (rather than narrow) leading to errors.
Is there anywhere I can read-up on iterative calculations in Excel?

Can you post the equation. We might be able to trap the input variable,
and make sure the equation does not diverge.
Dana


petersampson wrote:
I use a spreadsheet with indirect circular cell references. When it works I
observe the iterations narrowing until I have a verifiable answer. However,
the iterations often expand (rather than narrow) leading to errors.
Is there anywhere I can read-up on iterative calculations in Excel?

Thanks for the offer Dana, the iterative calculation is contained on a
spreadsheet. Am I able to post the worksheet on this message?
Peter

"Dana DeLouis" wrote:

Can you post the equation. We might be able to trap the input variable,
and make sure the equation does not diverge.
Dana


petersampson wrote:
I use a spreadsheet with indirect circular cell references. When it works I
observe the iterations narrowing until I have a verifiable answer. However,
the iterations often expand (rather than narrow) leading to errors.
Is there anywhere I can read-up on iterative calculations in Excel?