Tracking changes to a cell containing formula

[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

 

[Frank Kabel]

Hi
have a look at 'Tools - Track changes'

 

[Dinos]

This works when you directly change a cell value, not when you want t
track changes that change due to a formula recalculation.
Any other idea?

 

[Stephen Bye]

Select the cell containing the formula, then use Tools > Auditing > Trace
Dependants to show which cells are directly affected when the value in your
selected cell changes.

 

[Dinos]

Thanks Stephen but the problem is the cells with the formula are in
different sheet and you cannot trace the changes in that way.

 

[AlfD]

Meanwhile: Dinos (remember? The OP?)

Two possibilities spring to mind:

1. You could use a repeater cell on your "front" screen to tell yo
what is in the hidden cell.

2. You could create a small userform with a label which (probably usin
the on_change event of the hidden sheet) would repeat the hidden cell'
value.

Al