Forum Discussion

Copper Contributor

Nov 07, 2023

Solved

Form questions in wrong order in Excel download

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 h...

GideonHuang
Nov 20, 2023
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

simon965

Copper Contributor

Nov 08, 2023

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

simon965

Copper Contributor

Nov 16, 2023

GideonHuang Please advise on this problem, thanks.

GideonHuang
Microsoft
Nov 20, 2023
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
- simon965
  Copper Contributor
  Nov 21, 2023
  That has not solved it.
  - GideonHuang
    Microsoft
    Nov 22, 2023
    Simon, is it possible to share us your form link by email (gihuang@microsoft.com)?