Forms total points column content missing in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-799667%22%20slang%3D%22en-US%22%3EForms%20total%20points%20column%20content%20missing%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799667%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20used%20Forms%20now%20for%20many%20months%20and%20used%20to%20check%20the%20quiz%20results%20by%20downloading%20excel%20sheet.%20Everything%20has%20worked%20fine%20till%20last%20week%3A%20on%20downloaded%20excel%20the%20total%20points%20column%20can%20be%20seen%20but%20there%20is%20no%20points%2Fnumbers%20in%20the%20colmn%20(like%20it%20used%20to%20be).%20I%20have%20not%20made%20any%20changes%20on%20the%20original%20quiz.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20somebody%20help%3F%20How%20can%20I%20get%20the%20total%20points%20showing%20in%20excel%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETanks%2C%3C%2FP%3E%3CP%3EPetra%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-799667%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-799807%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20total%20points%20column%20content%20missing%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799807%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20the%20same%20issues%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F390771%22%20target%3D%22_blank%22%3E%40Petra_Lattunen%3C%2FA%3E%26nbsp%3B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPreviously%20(last%20Year)%20there%20were%20issues%20when%20the%20number%20of%20responses%20went%20over%202000%20then%20I%20believe%20this%20was%20fixed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20ask%20how%20many%20responses%20your%20report%20has%3F%26nbsp%3B%20I%20just%20wonder%20if%20that%20is%20part%20of%20the%20problem%20or%20whether%20it%20is%20a%20wider%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-799821%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20total%20points%20column%20content%20missing%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799821%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20your%20reply%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F147882%22%20target%3D%22_blank%22%3E%40Andrew%20Young%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20the%20same%20issue%2C%20but%20there%20is%20only%20580%20responses%20on%20my%20quiz%20so%20perhaps%20that%C2%B4s%20not%20the%20issue%20or%20what%20do%20you%20think%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-799827%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20total%20points%20column%20content%20missing%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799827%22%20slang%3D%22en-US%22%3EI've%20tested%20with%20as%20little%20as%205%20responses%20and%20the%20still%20the%20points%20don't%20show.%20So%20there%20must%20be%20an%20issue%20with%20MS%20FORMS%20from%20there%20end.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-799833%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20total%20points%20column%20content%20missing%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799833%22%20slang%3D%22en-US%22%3EOk%2C%20what%20can%20I%20do%20next%3F%20Any%20suggestions%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-799853%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20total%20points%20column%20content%20missing%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F390771%22%20target%3D%22_blank%22%3E%40Petra_Lattunen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20there%20is%20a%20way%20we%20can%20report%20this%20to%20microsoft%20or%20MS%20FORMS%20admin%20or%20something.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20work%20around%2C%20I%20completed%20the%20quiz%20with%20all%20the%20questions%20answered%20correctly%20and%20then%20added%20an%20'IF'%20function%20in%20the%20points%20column%20to%20check%20against%20the%20correct%20answer%2C%20if%20correct%20return%20a%20'1'%20if%20not%20a%20'0'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFinally%20added%20a%20sum%20function%20in%20the%20total%20points%20column%20to%20added%20them%20all%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShouldn't%20have%20to%20do%20it%20and%20its%20a%20pain%20but%20its%20a%20workaround%20until%20they%20fix%20it.%26nbsp%3B%20Depending%20on%20how%20many%20questions%20you%20have%20this%20is%20either%20a%20minor%20task%20or%20a%20major%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-800119%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20total%20points%20column%20content%20missing%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800119%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20the%20exact%20same%20issue.%20Columns%20in%20Excel%20just%20come%20out%20empty%20since%20last%20week.%20What%20gives%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-800573%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20total%20points%20column%20content%20missing%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800573%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F390771%22%20target%3D%22_blank%22%3E%40Petra_Lattunen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EI'm%20having%20exactly%20the%20same%20problem.%20I%20would%20appreciate%20a%20solution%20to%20MS%20before%20the%20new%20school%20year%20begins.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802295%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20total%20points%20column%20content%20missing%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802295%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F390771%22%20target%3D%22_blank%22%3E%40Petra_Lattunen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3ELooks%20like%20it's%20been%20fixed.%20I%20just%20opened%20the%20excel%20of%20a%20forms%20and%20the%20total%20points%20column%20with%20the%20results%20already%20appears.%20Thanks%20microsoft%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802298%22%20slang%3D%22en-US%22%3ERE%3A%20Forms%20total%20points%20column%20content%20missing%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802298%22%20slang%3D%22en-US%22%3EHooray%2C%20it%20works!%20Indeed%20thank%20you%20Microsoft.%20An%20thank%20you%20all%20about%20your%20help%20and%20support!%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

 

I have used Forms now for many months and used to check the quiz results by downloading excel sheet. Everything has worked fine till last week: on downloaded excel the total points column can be seen but there is no points/numbers in the colmn (like it used to be). I have not made any changes on the original quiz.

 

Can somebody help? How can I get the total points showing in excel again.

 

Tanks,

Petra

9 Replies

I'm having the same issues here @Petra_Lattunen .

 

Previously (last Year) there were issues when the number of responses went over 2000 then I believe this was fixed.

 

Can I ask how many responses your report has?  I just wonder if that is part of the problem or whether it is a wider issue.

Thank you for your reply@Andrew Young ,

 

I was wondering the same issue, but there is only 580 responses on my quiz so perhaps that´s not the issue or what do you think?

I've tested with as little as 5 responses and the still the points don't show. So there must be an issue with MS FORMS from there end.
Ok, what can I do next? Any suggestions?

@Petra_Lattunen 

 

I don't know if there is a way we can report this to microsoft or MS FORMS admin or something.

 

As a work around, I completed the quiz with all the questions answered correctly and then added an 'IF' function in the points column to check against the correct answer, if correct return a '1' if not a '0'.

 

Finally added a sum function in the total points column to added them all up.

 

Shouldn't have to do it and its a pain but its a workaround until they fix it.  Depending on how many questions you have this is either a minor task or a major one.

 

 

I'm having the exact same issue. Columns in Excel just come out empty since last week. What gives?

@Petra_Lattunen 

I'm having exactly the same problem. I would appreciate a solution to MS before the new school year begins.

@Petra_Lattunen 

Looks like it's been fixed. I just opened the excel of a forms and the total points column with the results already appears. Thanks microsoft

Hooray, it works! Indeed thank you Microsoft. An thank you all about your help and support!