Tracking changes in cell

  • Thread starter Thread starter Dinos
  • Start date Start date
D

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 this is when you directly change a value to a cell, not when it i
recalculated because it contains a formula
Any other idea
 
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?
 
Back
Top