Missing Data in Excel spreadsheet of Microsoft Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-1526346%22%20slang%3D%22en-US%22%3EMissing%20Data%20in%20Excel%20spreadsheet%20of%20Microsoft%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526346%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20form%20of%20around%2040%20questions%20to%20gather%20data%20from%20employees.%20Now%20i%20have%20more%20than%20200%20responses%20on%20that.%20When%20i%20download%2Fopen%20the%20results%20in%20excel%20sheet%2C%20half%20of%20the%20question's%20responses%20(entire%20columns)%20are%20missing.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20now%20how%20to%20fix%20this%2C%20the%20form%20is%20still%20active%20with%20no%20changes%20made%20to%20the%20questions.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1526346%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1751442%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Data%20in%20Excel%20spreadsheet%20of%20Microsoft%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1751442%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730672%22%20target%3D%22_blank%22%3E%40asmawali92%3C%2FA%3E%26nbsp%3B%20I%20have%20similar%20issue.%20ID%20is%20still%20cumulative%20so%20row%201%20is%20ID%201960%20but%20I%20cannot%20see%20Response%20ID%201%20to%201959%20but%20could%20see%20them%20a%20few%20days%20ago.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I created a form of around 40 questions to gather data from employees. Now i have more than 200 responses on that. When i download/open the results in excel sheet, half of the question's responses (entire columns) are missing. 

 

Please let me now how to fix this, the form is still active with no changes made to the questions. 

1 Reply
Highlighted

@asmawali92  I have similar issue. ID is still cumulative so row 1 is ID 1960 but I cannot see Response ID 1 to 1959 but could see them a few days ago.