software

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

It would be like adding a quot;Watchquot; on all of the formula cells, only the
information would include the order in which the formulas were
executed.

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

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

thanks,
Dan--
dano2
------------------------------------------------------------------------
dano2's Profile: www.excelforum.com/member.php...oamp;userid=30608
View this thread: www.excelforum.com/showthread...hreadid=502611I 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.quot;dano2quot; gt;
wrote in message
...
gt;
gt; Does anyone know if there's a way to list all of the formulas
gt; that have
gt; been executed and the order in which they were executed when a
gt; given
gt; action has taken place? An action being, the populating of a
gt; cell
gt; (which starts a chain reaction of other cells being populated
gt; via their
gt; respective formulas).
gt;
gt; It would be like adding a quot;Watchquot; on all of the formula cells,
gt; only the
gt; information would include the order in which the formulas were
gt; executed.
gt;
gt; It would be nice if it could also include dependant cells
gt; affected on
gt; other worksheets as well.
gt;
gt; Please note: I'm not inquiring about INTRAformula precendence.
gt; I guess
gt; you could call it INTERformula precendence, though, if that
gt; helps.
gt;
gt; thanks,
gt; Dan
gt;
gt;
gt; --
gt; dano2
gt; ------------------------------------------------------------------------
gt; dano2's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30608
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=502611
gt;