Formula

[Monty]

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

 

[Andrea Jones]

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]

Andrea

Thanks

This is one area i didnt check as i assumed staff would not know how to do
this.

Monty

 

[Bryan Hessey]

Check Tools, Options, Calculation is still set for Automatic

 

[Ragdyer]

This doesn't have to be *intentional*!

Check out this old post:

http://tinyurl.com/anahg