G Guest Oct 29, 2007 #1 All of a sudden, the SUM function is no longer working. I enter a new number in the cell and the SUM does not get updated.
All of a sudden, the SUM function is no longer working. I enter a new number in the cell and the SUM does not get updated.
P Pete_UK Oct 29, 2007 #2 Check out Tools | Options | Calcualtion tab - is the calculation mode set to manual? Click on Automatic if it is. You can always press F9 if it is set to Manual to force a recalculation. Hope this helps. Pete
Check out Tools | Options | Calcualtion tab - is the calculation mode set to manual? Click on Automatic if it is. You can always press F9 if it is set to Manual to force a recalculation. Hope this helps. Pete