Hi

In addition to Fred's suggestion, if you look at the far right of the
Formulas tab, there is an option to Calculate Now, and to set the
Calculation mode Options.

--

Regards
Roger Govier

"Cash" wrote in message
...
How do I set the calculations to update automatically?
I have checked the settings have been set to update automatically.
(no need for F9)