Nov 07 2023 03:50 AM
Hi,
My form questions and answer download to my spreadsheet in to a different order, mixing up question categories.
I do not have the option to sync to a new workbook available to me.
I have also tried signing in and out.
Please advise how I can fix this issue.
Thanks
Simon
Nov 07 2023 06:22 PM
Nov 07 2023 06:34 PM - edited Nov 07 2023 06:35 PM
Simon, 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
Nov 08 2023 12:32 AM
Hi @Gideon Huang, 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
Nov 16 2023 07:24 AM
@Gideon Huang Please advise on this problem, thanks.
Nov 20 2023 08:43 AM
Solution@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
Nov 21 2023 04:40 PM
Dec 06 2023 12:05 AM
Nov 20 2023 08:43 AM
Solution@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