Sums
 

My excel seems to have locked up. When I change a figure (number), it
no longer automatically puts correctly updates the sum.

ie. If I had 25 (A1) +10 (A2)+ 5(A3) and I had =Sum (A1:A3), the
formula would show me 40.

However, if I change A1 to 35 (from 25), the Sum is not automatically
adjusting to show me 50.

I cant seem to find the setting that is causing this to happen.

In addition, the 'fill right', 'fill down' functions are similarly
disabled.

Help would be great.


--
cosmos5955
------------------------------------------------------------------------
cosmos5955's Profile: http://www.excelforum.com/member.php...o&userid=33003
View this thread: http://www.excelforum.com/showthread...hreadid=528264

Sums
 

It sounds like you have calculation set to Manual. Try chnging it to
Automatic by selecting Tools Options Calculation Automatic

--
HTH

Sandy

with @tiscali.co.uk


"cosmos5955" wrote
in message ...

My excel seems to have locked up. When I change a figure (number), it
no longer automatically puts correctly updates the sum.

ie. If I had 25 (A1) +10 (A2)+ 5(A3) and I had =Sum (A1:A3), the
formula would show me 40.

However, if I change A1 to 35 (from 25), the Sum is not automatically
adjusting to show me 50.

I cant seem to find the setting that is causing this to happen.

In addition, the 'fill right', 'fill down' functions are similarly
disabled.

Help would be great.


--
cosmos5955
------------------------------------------------------------------------
cosmos5955's Profile:
http://www.excelforum.com/member.php...o&userid=33003
View this thread: http://www.excelforum.com/showthread...hreadid=528264