Try clicking on Tools - Options and look under the Calculation section.
Make sure the bullet is in Automatic and not manual otherwise Excel won't
automatically update formulae when you change the values.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"Monty" wrote:

i have a workbook with some basic formula =sum(H6:H33) this was working fine
until yesterday. This formula will only work now when you click on the
formula bar.

any suggestions welcome

Cheers

Monty