ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   the sum func is not working. Enter a new # & the Sum is not upda (https://www.excelbanter.com/excel-discussion-misc-queries/163924-sum-func-not-working-enter-new-sum-not-upda.html)

mc

the sum func is not working. Enter a new # & the Sum is not upda
 
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

Pete_UK

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





All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com