Hi I just posted a similar question and this has answered my problem! I am
not sure why some of my worksheets have had the calc mode changed but at
least I can fix it now. Thanks!

"Max" wrote:

Sounds like a calc mode issue (calc is accidentally set to manual mode).
Check that calc is set to automatic, via ToolsOptionsCalculation tab.
Options to change the calc mode are there.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Lozza65" wrote:
I have formulars in an excel spreadsheet. At the moment when I change a cell
the summing formula is not updating the total. The formula is correct but I
have to re sum the column for the total to adjust to the new total