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