Thread: the sum func is not working. Enter a new # & the Sum is not upda
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default the sum func is not working. Enter a new # & the Sum is not upda
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

On Oct 29, 2:45 pm, mc <april67 wrote:
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.
--
mc


Reply With QuoteReply With Quote