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