Autosum

S

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
 
M

Morrigan

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


Hope that helps.
 
G

giantwolf

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

Stuart Perry

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

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!
==============================================
 
Top