Forum Discussion
DON CULP
Jul 18, 2018Copper Contributor
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...
- 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
Jul 18, 2018Copper Contributor
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
Sep 16, 2018Copper Contributor
Thanks, it worked for me too.
- Heather DoyleOct 03, 2018Copper ContributorThanks, Me too! No idea how this would have gotten changed in the first place.