Thread: Sum of cells not updating when cell changed.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Sum of cells not updating when cell changed.
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
Reply With QuoteReply With Quote