SOLVED

Sums & Totals no longer calculating

%3CLINGO-SUB%20id%3D%22lingo-sub-216788%22%20slang%3D%22en-US%22%3ESums%20%26amp%3B%20Totals%20no%20longer%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216788%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20set%20up%20spread%20sheets%20to%20keep%20track%20of%20job%20totals%20and%20independent%20contractor%20pay.%26nbsp%3B%20These%20are%20simple%20%22SUM%22%20and%20%22MULTIPLY%22%20functions.%26nbsp%3B%20Up%20until%20about%202%20weeks%20ago%2C%20I%20would%20enter%20numbers%20and%20totals%20would%20appear.%26nbsp%3B%20Now%2C%20I%20enter%20numbers%20and%20totals%20%26amp%3B%20calculations%20no%20longer%20work.%26nbsp%3B%20I%20have%20to%20highlight%20the%20cell%2C%20click%20in%20the%20address%20bar%20where%20it%20says%20%22%3DSUM(field%3Afield)%22%20then%20click%20the%20Check%20Mark%20to%20the%20left%20to%20make%20it%20show%20the%20total.%3C%2FP%3E%3CP%3EI%20am%20working%20in%20%222018%22.%26nbsp%3B%20The%20sheet%20%222017%22%20has%20been%20done%20since%20Dec%202017%20and%20I%20went%20into%20it%20today%20and%20I%20have%20the%20same%20issues%20on%20that%20sheet%20as%20well.%26nbsp%3B%20So%20it%20seems%20like%20something%20went%20wrong%20with%20Excel.%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20get%20the%20calculations%20and%20formulas%20to%20start%20working%20again%20without%20having%20to%20redo%20the%20entire%20document%3F%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-216788%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20%26amp%3B%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266533%22%20slang%3D%22en-US%22%3ERe%3A%20Sums%20%26amp%3B%20Totals%20no%20longer%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266533%22%20slang%3D%22en-US%22%3EThanks%2C%20Me%20too!%20No%20idea%20how%20this%20would%20have%20gotten%20changed%20in%20the%20first%20place.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-253224%22%20slang%3D%22en-US%22%3ERe%3A%20Sums%20%26amp%3B%20Totals%20no%20longer%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253224%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20it%20worked%20for%20me%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-226162%22%20slang%3D%22en-US%22%3ERe%3A%20Sums%20%26amp%3B%20Totals%20no%20longer%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-226162%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20checked%20the%20settings%20yet%20when%20I%20try%20to%20sum%20the%20only%20thing%20I%20get%20is%20the%20%22sum%20formula%22.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EEven%20if%20I%20try%20to%20type%26nbsp%3B%40sum(%23%3A%23)%20it%20just%20doesnt%20work.%26nbsp%3B%3C%2FP%3E%3CP%3EDarlene%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EHi%20Don%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20in%20ribbon%20Formulas%20tab-%26gt%3BCalculation%20Options%20in%20drop%20down%20menu%20if%20it%20set%20on%20Automatic.%3C%2FP%3E%3CP%3EOr%20File-%26gt%3BOptions-Formulas%20and%20here%20select%20Automatic%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216824%22%20slang%3D%22en-US%22%3ERe%3A%20Sums%20%26amp%3B%20Totals%20no%20longer%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216824%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20too!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216823%22%20slang%3D%22en-US%22%3ERe%3A%20Sums%20%26amp%3B%20Totals%20no%20longer%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216823%22%20slang%3D%22en-US%22%3E%3CP%3EI%20followed%20your%20instructions%20and%20it%20was%20set%20to%20Manual.%26nbsp%3B%20Clicked%20Automatic%20and%20they%20started%20working%20again.%26nbsp%3B%20Thank%20you%20very%20much.%26nbsp%3B%20I%20would%20have%20never%20known%20where%20to%20look%20for%20that.%3C%2FP%3E%3CP%3EHave%20a%20great%20day!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216814%22%20slang%3D%22en-US%22%3ERe%3A%20Sums%20%26amp%3B%20Totals%20no%20longer%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216814%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Don%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20in%20ribbon%20Formulas%20tab-%26gt%3BCalculation%20Options%20in%20drop%20down%20menu%20if%20it%20set%20on%20Automatic.%3C%2FP%3E%0A%3CP%3EOr%20File-%26gt%3BOptions-Formulas%20and%20here%20select%20Automatic%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2489635%22%20slang%3D%22en-US%22%3ERe%3A%20Sums%20%26amp%3B%20Totals%20no%20longer%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2489635%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20the%20same%20issue%20with%20the%20SUM%20function%20not%20calculating%2C%20but%20displaying%20the%20SUM%20function.%20%26nbsp%3BI%20have%20verified%20that%20my%20Calculation%20Options%20is%20set%20to%20Automatic.%20%26nbsp%3BWhat%20can%20be%20the%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ERoxane%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2489636%22%20slang%3D%22en-US%22%3ERe%3A%20Sums%20%26amp%3B%20Totals%20no%20longer%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2489636%22%20slang%3D%22en-US%22%3Ecorrection%3A%20the%20SUM%20function%20is%20displaying%20the%20SUM%20formula.%20Thank%20you.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

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 would appear.  Now, I enter numbers and totals & calculations no longer work.  I have to highlight the cell, click in the address bar where it says "=SUM(field:field)" then click the Check Mark to the left to make it show the total.

I am working in "2018".  The sheet "2017" has been done since Dec 2017 and I went into it today and I have the same issues on that sheet as well.  So it seems like something went wrong with Excel.

Is there any way to get the calculations and formulas to start working again without having to redo the entire document?

Thank you for your help in advance.

8 Replies
best response confirmed by DON CULP (New Contributor)
Solution

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

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!!!

You too!

I have checked the settings yet when I try to sum the only thing I get is the "sum formula".  

Even if I try to type @sum(#:#) it just doesnt work. 

Darlene

 


@Sergei Baklan wrote:

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


 

Thanks, it worked for me too.

 

Thanks, Me too! No idea how this would have gotten changed in the first place.

 

 

I am having the same issue with the SUM function not calculating, but displaying the SUM function.  I have verified that my Calculation Options is set to Automatic.  What can be the issue?

 

Thank you,

Roxane

 

correction: the SUM function is displaying the SUM formula. Thank you.