What happens if you set calculation to Automatic?

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Erin" wrote in message
...
Hello All,

Can anyone think of a reason why a cell containing the
formula =IF(Master!CA74=0,"",Master!CA74), won't
recalculate when I enter a number into Master!CA74 unless
I physically go to the cell with the formula and F2, Enter?

Calculation is set to Manaual.
The status bar reads Ready (not Calculate).
F9 has no effect.

Any suggestions would be greatly appreciated.

Thanks.

Erin