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

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

Andrea

Thanks

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

Monty

"Andrea Jones" wrote:

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

Check Tools, Options, Calculation is still set for Automatic



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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=392815

This doesn't have to be *intentional*!

Check out this old post:

http://tinyurl.com/anahg

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Monty" wrote in message
...
Andrea

Thanks

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

Monty

"Andrea Jones" wrote:

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

i'm not gay and no it doesn't have to be Intentional


"Ragdyer" wrote:

This doesn't have to be *intentional*!

Check out this old post:

http://tinyurl.com/anahg

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Monty" wrote in message
...
Andrea

Thanks

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

Monty

"Andrea Jones" wrote:

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