Forum Discussion
Form questions in wrong order in Excel download
simon965 Sorry for response late. I can't repro the your issue for my forms. Was your issued form created for long time? Could you please to move up and move back the likert question, it will regenerate the question's order and we can check whether the issue is resolved. Thanks
MicrosoftSimon, I guess this form is not a group form and not created from Excel or ODSP. So the form doesn't connect to an online workbook file for live data sync, and no option for "sync to a new workbook" since every "open in excel" would download a new workbook.
For wrong question order in excel problem, did you check the "Shuffle questions" in the form's setting? Is the questions' order wrong for every time you click "open in excel" for new workbook?
Thanks
Hi GideonHuang, thanks for the quick response.
It is a form created on Microsoft forms, I'm only using Excel for analysis.
Once the responses are downloaded to the Excel workbook, the questions themselves are shuffled, and mixed seemingly randomly, with some Likert scale-type answers mixed in with open-ended answers, so it is not a problem of shuffling response options (this is turned off, anyway), as question and response order should be consistent for the form's purpose.
The order in which the workbook incorrectly loads the data is consistent every time I open the workbook.
Please advise.
Thanks
GideonHuang Please advise on this problem, thanks.
- GideonHuang
simon965 Sorry for response late. I can't repro the your issue for my forms. Was your issued form created for long time? Could you please to move up and move back the likert question, it will regenerate the question's order and we can check whether the issue is resolved. Thanks
