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

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

"Stuart Perry" wrote:

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

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


"Stuart Perry" wrote in message
...
Please do not reply as I have sorted this out
It is a setting under calculations that she denies changing lol

"Stuart Perry" wrote:

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

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


Hope that helps.



Stuart Perry Wrote:
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
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388399

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


--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=388399

Ah, beat me to it!


--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=388399