Refresh Excel question order when rearranging MS Forms questions
I have had to rearrange the question order in my Form when creating a survey, yet when I open the Form in Excel the columns are in completely the wrong order, and there are even blank column headers rather than questions.
I have tried to move the columns around on the Excel sheet, but keep receiving an error message. I have tried 'Refreshing all connections' to see if that rectified the issue, but have has no success.
There either needs to be a live refresh built into Forms for Excel, or there should be an option to be able to refresh the connection.
I am really disappointed, as I spent a long time creating the Form and now feel that in its current state in is unusable and will need to be created again.
Please rectify this issue.