INTERformula precendence

[dano2]

Does anyone know if there's a way to list all of the formulas that hav
been executed and the order in which they were executed when a give
action has taken place? An action being, the populating of a cel
(which starts a chain reaction of other cells being populated via thei
respective formulas).

It would be like adding a "Watch" on all of the formula cells, only th
information would include the order in which the formulas wer
executed.

It would be nice if it could also include dependant cells affected o
other worksheets as well.

Please note: I'm not inquiring about INTRAformula precendence. I gues
you could call it INTERformula precendence, though, if that helps.

thanks,
Da

 

[Chip Pearson]

I don't think there is any way to do this. You can use the Show
Precedence and Show Dependents tools on the Auditing command bar
to see which cells are dependent on which other cells, but there
is no way to determine the order of calculation of anything but
the most simple workbook.


"dano2" <[email protected]>
wrote in message
news:[email protected]...