excel calculations

[Jacques]

Need a window which acts like VB debugger, but shows each
step that excel is performing. As in the case of circular
reference calculations, one could watch in the order at
which excel computes each cell. So if you have Cells A1,
A2, A3, A4, A5, and A1 is used to compute A2-5, and A2 is
used to calculate A1, A3-5, and so forth through A5 used
to calculate A1-4. I have tried to repeat the calculation
long hand 10 different ways and can not come up with the
same information. It would be beneficial to see how excel
starts each and completes each computation and which
order. It could be used to write more indepth macro's and
such.

 

[JE McGimpsey]

AFAIK, there's no hook into the calculation engine. You can see a
description of the calculation engine works here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k
2/html/odc_xlrecalc.asp