Hi,

In 2007 choose Formulas, Calculation Options, Automatic

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Andey9" wrote:

The formula will only update when i hit the same button - have checked
"options" within "Tools" but everything seems ok - any ideas?

thanks