Autosum

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.

Originally Posted by 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

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

Ah, beat me to it!

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" <StuartPerry@discussions.microsoft.com> wrote in message
news:B2A98EA5-D0B5-4E4F-BEAF-B54F667CC8F3@microsoft.com...
> 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