Formulas will not update!

I don’t know if anyone can help me but this problem is frustrating me.
I will try to explain as best I can. When I have a column of data, say
reference
A1 to A9 with a formula beneath it in A10 being that the formula is
=SUM(A1:A9) when I update any of the data in A1 to A9 the figure in A10
does not update. The only way to get it to update is to click in A10
where the formula is and then click in the formula bar and press enter;
the formula seems to recalculate after this and it works or you need to
save it and it works. It should work right after any change in the
data being added, I don't know what is happening or has happened but
any solution to this problem would be much appreciated.

Thanks:



--
cerpintax
------------------------------------------------------------------------
cerpintax's Profile: http://www.excelforum.com/member.php...o&userid=35411
View this thread: http://www.excelforum.com/showthread...hreadid=551805

Hi

Make sure that your calculation is set to Automatic. It's in
Tools/Optopns/Calculation

Hope this helps.
Andy.

"cerpintax" wrote
in message ...

I don’t know if anyone can help me but this problem is frustrating me.
I will try to explain as best I can. When I have a column of data, say
reference
A1 to A9 with a formula beneath it in A10 being that the formula is
=SUM(A1:A9) when I update any of the data in A1 to A9 the figure in A10
does not update. The only way to get it to update is to click in A10
where the formula is and then click in the formula bar and press enter;
the formula seems to recalculate after this and it works or you need to
save it and it works. It should work right after any change in the
data being added, I don't know what is happening or has happened but
any solution to this problem would be much appreciated.

Thanks:



--
cerpintax
------------------------------------------------------------------------
cerpintax's Profile:
http://www.excelforum.com/member.php...o&userid=35411
View this thread: http://www.excelforum.com/showthread...hreadid=551805

Thanks Andy, that was the problem. Sorted now, don't know how it
switched over to manual. Thanks again though


--
cerpintax
------------------------------------------------------------------------
cerpintax's Profile: http://www.excelforum.com/member.php...o&userid=35411
View this thread: http://www.excelforum.com/showthread...hreadid=551805

Thanks for the feedback. The first book opened in a session determines
whether calculation is set to manual or automatic.

Andy.

"cerpintax" wrote
in message ...

Thanks Andy, that was the problem. Sorted now, don't know how it
switched over to manual. Thanks again though


--
cerpintax
------------------------------------------------------------------------
cerpintax's Profile:
http://www.excelforum.com/member.php...o&userid=35411
View this thread: http://www.excelforum.com/showthread...hreadid=551805