the sum func is not working. Enter a new # & the Sum is not upda

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers showing Up Centered in Cell ? 1
Help Writing a SUM Formula 5
sum to recognize new rows 3
Access Sum function in an Access Form 1
Error when using Sum command 3
sum last 3 numbers greater that 0 in a range 0
How to copy the function SUM but offseted in 7 columns 2
SUM Function 1

Back
Top