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
LloydCMU
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
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.

@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.

Calculation set to manual perhaps?
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.

@Jan Karel Pieterse 

 

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

 

Thanks for your help.

 

Lloyd

@Twifoo 

 

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

 

Thanks,

 

Lloyd

You're welcome.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies