Tracking changes in cell

[Dinos]

I want to track changes to cells because a formula calculates a ne
value, not because i changed directly the value of a cell.
the excel help indicate the following:
Cells that change because a formula calculates a new value---> To fin
cells that change due to recalculation, use the tools on the Auditin
toolbar.

How to do that? The formula auditing toolbar doesn't seem to hav
something like that...

thanks for your tim

 

[Andy B]

Hi

Have a look at Tools / Track Changes.

 

[Dinos]

Andy this is when you directly change a value to a cell, not when it i
recalculated because it contains a formula
Any other idea

 

[Frank Kabel]

Hi
if you also need to track re-calculations you would need an event
procedure that uses the worksheet_claculate event and store manually
the values of specific cells into a separate sheet/file.
AFAIK no chance without this. Would this be a feasible way for you?

 

[Dinos]

I will try Frank, thought i don't know the procedure
Thank

 

[Frank Kabel]

Hi
I'll look into this this evening and prepare an example for you