Autosum

[Stuart Perry]

PLEASE HELP

Our Finance Manager has done something to her spreadsheets!!!!!!

If you do an autosum on an existing spreadsheet it works okay, but it you
amend the sum it does not see the change, for example an autosum of 5+5 =10
but remove on of the 5's and the total is still 10!!! It works okay on any
new spreadsheets.

Any ideas

 

[Morrigan]

Check Tools -> Options -> Calculation
Make sure Automatic is checked not Manual.


Hope that helps.

 

[giantwolf]

Go to "tools", "options" and on the "calculation" tab make sure th
automatic option is checked

 

[giantwolf]

Ah, beat me to it!

 

[Stuart Perry]

Please do not reply as I have sorted this out
It is a setting under calculations that she denies changing lol

 

[RagDyer]

She might very well be telling the truth!

Check out this old post:

http://tinyurl.com/anahg

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================