Automatic SUM Recalculation

Copper Contributor

I'm an Excel novice.  How do I turn on automatic SUM recalculation, when a value within the SUM range changes?  Currently, I have to click on the SUM field to get it to recalculate.

Thanks for the help !

3 Replies

@Zip_Allen 

Be sure Calculation option is in automatic mode. That is for Windows, something similar shall be for Mac

image.png

@Zip_Allen 

Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic, and that you don't have circular references.

Thank you ! That did it! I really appreciate the quick response.