Why has the sum function stopped auto-updating?

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

Guest

I have a workbook with multiple worksheets that I have been using all year
but all the sum functions have now stopped auto-updating. So if I type a new
value into one of the cells that make up the "sum" the sum does not change.
If I try to copy and paste the sum function from the next column, it retains
the value of the original sum. If I manually type a new sum formula into the
cell it returns the correct value.

All values are numbers not text strings.

Any suggestions gratefully received!
 
It could be that you've altered how Excel calculates.

Go to Tools ---> Options ---> Calculation

Check to see if it's set to manual.

HTH.
 
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

Copy paste data from a column to a row 0
Cant use sum function or status bar 1
Sum cell value across multiple worksheets. 10
How to copy the function SUM but offseted in 7 columns 2
paste special values does not tabulate 5
Summing up various Worksheets to one Summary sheet using variables 1
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
Sum column of cells that already contain a formula 2

Back
Top