suming working ok but now not auto updating totals after changes
 

Ive been using a sheet for my expences for months. all ok on all sheets. now
any changes i make to the columns make no difference to the result. If I
check the sum its still ok. any help wold be appreciated.

suming working ok but now not auto updating totals after changes
 

Try this:

From the Excel Main Menu:
<tools<options<calculation tab
Automatic should be checked. (is it?)

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"colin bellamy" wrote in message
...
Ive been using a sheet for my expences for months. all ok on all sheets.
now
any changes i make to the columns make no difference to the result. If I
check the sum its still ok. any help wold be appreciated.