Incomplete and random responses in Excel workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1097649%22%20slang%3D%22en-US%22%3EIncomplete%20and%20random%20responses%20in%20Excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1097649%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20when%20I%20click%20on%20%22open%20in%20Excel%22%2C%20the%20Excel%20workbook%20does%20not%20show%20all%20the%20responses%20-%20some%20cells%20are%20empty.%20For%20example%2C%20I%20can%20see%20a%20respondent's%20answers%20to%20question%201%2C%203%2C%205%2C%20but%20not%202%20and%204.%20This%20happens%20randomly%20to%20every%20answer.%20What's%20also%20puzzling%20is%20that%20the%20workbook%20also%20does%20not%20include%20timestamps%20and%20the%20respondents'%20names%20(the%20option%20for%20showing%20names%20is%20selected).%26nbsp%3B%3C%2FP%3E%3CP%3EAnybody%20knows%20what's%20going%20on%3F%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1097649%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%20-%20Something%20went%20wrong%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1097681%22%20slang%3D%22en-US%22%3ERe%3A%20Incomplete%20and%20random%20responses%20in%20Excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1097681%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20the%20answer%20to%20my%20own%20question!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20825px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164357i2DFD9B1C06C0CE9F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22forms.PNG%22%20title%3D%22forms.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1101436%22%20slang%3D%22en-US%22%3ERe%3A%20Incomplete%20and%20random%20responses%20in%20Excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1101436%22%20slang%3D%22en-US%22%3EHi%2C%20my%20FORMS%20don't%20have%20the%20%22Ideas%22%20button%20or%20option%20to%20%22sync%20with%20new%20workbook%22%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20strange.....%3C%2FLINGO-BODY%3E
New Contributor

Hi, when I click on "open in Excel", the Excel workbook does not show all the responses - some cells are empty. For example, I can see a respondent's answers to question 1, 3, 5, but not 2 and 4. This happens randomly to every answer. What's also puzzling is that the workbook also does not include timestamps and the respondents' names (the option for showing names is selected). 

Anybody knows what's going on? Thank you!

2 Replies

I found the answer to my own question! 

 

forms.PNG

Hi, my FORMS don't have the "Ideas" button or option to "sync with new workbook"

How strange.....