Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-731561%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-731561%22%20slang%3D%22en-US%22%3E%3CP%3EI%20recently%20tride%20to%20input%20new%20data%20into%20a%20worksheet%20and%20it%20no%20longer%20will%20sum%20the%20total%20information.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20sheet%20is%20unprotected%2C%20curious%20what%20the%20issue%20might%20be%20to%20get%20the%20formulas%20to%20populate%20the%20results%20of%20additional%20data%20entered%3F%26nbsp%3B%20Where%20would%20I%20look%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELloyd%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-731561%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-731590%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-731590%22%20slang%3D%22en-US%22%3EPerhaps%20the%20cells%20are%20formatted%20as%20text.%20Format%20the%20cells%20as%20General%20and%20then%20re-enter%20all%20of%20the%20data%20(joking).%3CBR%20%2F%3ESerisouly%3A%20Select%20the%20cells%20in%20question%2C%20they%20should%20display%20a%20green%20triangle%20and%20a%20small%20icon%20pops%20up.%20Click%20the%20icon%20and%20have%20Excel%20convert%20the%20numbers%20to%20real%20numbers.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-731645%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-731645%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20feedback.%26nbsp%3B%20However%2C%20unfortunately%20the%20line%20items%20in%20question%20do%20not%20have%20the%20green%20triangle%2C%20they%20merely%20sum%20the%20totals%20above.%26nbsp%3B%20Up%20until%20today%20it%20worked%20just%20fine%2C%20pretty%20simple%20excel%20file%20yet%20the%20issue%20is%20bugging%20me%2C%20not%20sure%20what%20I%20could%20have%20clicked%20to%20have%20all%20the%20sum%20total%20formuals%20stop%20updating.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733619%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733619%22%20slang%3D%22en-US%22%3ECalculation%20set%20to%20manual%20perhaps%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733688%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733688%22%20slang%3D%22en-US%22%3EMy%20guess%20is%20that%20you%20inserted%20rows%20into%20which%20you%20entered%20additional%20data%20but%20such%20additional%20rows%20were%20not%20included%20in%20your%20SUM%20formula.%20Please%20check%20the%20range%20of%20your%20SUM%20formula%20and%20ensure%20that%20the%20additional%20rows%20are%20included%20therein.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-734288%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-734288%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20somehow%20they%20got%20turned%20to%20manual%2C%20that%20fixed%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELloyd%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-734292%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-734292%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%2C%20somehow%20the%20calculation%20got%20turned%20to%20manual.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELloyd%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-734323%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-734323%22%20slang%3D%22en-US%22%3EYou're%20welcome.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I recently tride to input new data into a worksheet and it no longer will sum the total information. 

The sheet is unprotected, curious what the issue might be to get the formulas to populate the results of additional data entered?  Where would I look?

 

Thanks,

 

Lloyd

7 Replies
Highlighted
Perhaps the cells are formatted as text. Format the cells as General and then re-enter all of the data (joking).
Serisouly: Select the cells in question, they should display a green triangle and a small icon pops up. Click the icon and have Excel convert the numbers to real numbers.
Highlighted

@Jan Karel Pieterse 

 

Thanks for the feedback.  However, unfortunately the line items in question do not have the green triangle, they merely sum the totals above.  Up until today it worked just fine, pretty simple excel file yet the issue is bugging me, not sure what I could have clicked to have all the sum total formuals stop updating.

Highlighted
Calculation set to manual perhaps?
Highlighted
My guess is that you inserted rows into which you entered additional data but such additional rows were not included in your SUM formula. Please check the range of your SUM formula and ensure that the additional rows are included therein.
Highlighted

@Jan Karel Pieterse 

 

Yes, somehow they got turned to manual, that fixed it.

 

Thanks for your help.

 

Lloyd

Highlighted

@Twifoo 

 

Thanks for your help, somehow the calculation got turned to manual.

 

Thanks,

 

Lloyd

Highlighted
You're welcome.