Forum Discussion

Copper Contributor

Jul 18, 2018

Solved

Sums & Totals no longer calculating

I have set up spread sheets to keep track of job totals and independent contractor pay. These are simple "SUM" and "MULTIPLY" functions. Up until about 2 weeks ago, I would enter numbers and totals...

Macros & VBA

Need Help

SergeiBaklan
Jul 18, 2018
Hi Don,

Please check in ribbon Formulas tab->Calculation Options in drop down menu if it set on Automatic.

Or File->Options-Formulas and here select Automatic

SergeiBaklan

Diamond Contributor

Jul 18, 2018

Hi Don,

Please check in ribbon Formulas tab->Calculation Options in drop down menu if it set on Automatic.

Or File->Options-Formulas and here select Automatic

DON CULP

Copper Contributor

Jul 18, 2018

I followed your instructions and it was set to Manual. Clicked Automatic and they started working again. Thank you very much. I would have never known where to look for that.

Have a great day!!!

MS Roberts
Copper Contributor
Sep 16, 2018
Thanks, it worked for me too.
- Heather Doyle
  Copper Contributor
  Oct 03, 2018
  Thanks, Me too! No idea how this would have gotten changed in the first place.
SergeiBaklan
Diamond Contributor
Jul 18, 2018
You too!