Forum Discussion
Zip_Allen
Jun 26, 2022Copper Contributor
Automatic SUM Recalculation
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 h...
HansVogelaar
Jun 26, 2022MVP
Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic, and that you don't have circular references.
- Zip_AllenJun 26, 2022Copper ContributorThank you ! That did it! I really appreciate the quick response.