formulas not calculating
the formula does not calculate, if I hit F2 & enter it works
"Tom Ogilvy" wrote:
David makes an interesting point.
do you mean the cell looks like
=Formula
so you see the formula instead of the result
or just that the formula doesn't recalculate when you change a value it is
dependent on.
--
Regards,
Tom Ogilvy
"Wade" wrote in message
...
Sorry Tom, That does not work
"Tom Ogilvy" wrote:
How about
Ctrl+shift+F9
--
Regards,
Tom Ogilvy
"Wade" wrote in message
...
I have a bunch of worksheets where the formulas work &
I have a bunch of work sheets where the formulas are not working
unless I
F2
and then hit enter on the cell.
I have checked tools,options, calculations & it is set to automatic.
The F9 key does not work either.
|