You will be be redirected to the blog in a moment...
Or you can click the link below to proceed:
SharePoint surveys and the order of the questions during export to Excel
I noticed some interesting, and in my case not desirable behaviour when I was exporting the results from a SharePoint survey to Excel: the order of the questions in Excel differed from the order in SharePoint.Some further analysis showed the following:When you export to Excel, the order is determined by the creation time of a question, so the questions that were create first appear before the others. This even happens after you reordered your questions in your survey, which was what I did.To give an example:I create a survey with 3 questions in the order 1,2,3:I then reorder them to 3,1,2:If I export them now to Excel, the order of the columns however is still 1,2,3:So in case you need to export to Excel and don't want to reorder your columns there afterwards, make sure you got the order right when you create your survey questions.
Want to be redirected immediately?
Register yourself at Ping.sg to get rid of this page and also to get your read counted as Pong.