Exporting a re-ordered survey
We have an individual that has created a fairly large survey that they do not want to redo. They had to re-order their questions on the site and when they export the results out to Excel, theresults arein the original order before they were re-ordered.Is there a way to get the export to extract the data in the new order of the survey questions? I have tested this with a small test survey with 5 questions and the same results. The isMOSS 2007and Excel 2007. Thanks to all for your help with this.
July 22nd, 2009 9:23pm

Hi, It is a known issue that survey question order set in "Change Question Order" page is not reflected when exporting the survey to spreadsheet. I am sorry there is no hotfix currently. The workaround is to create questions in the final order want to display in spreadsheet. So in case you need to export to Excel and don't want to reorder your columns in Excel, make sure you got the order right when you create your survey questions. Thanks for your understanding.Xue-Mei Chang
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2009 1:03pm

I would try saving your completed survey as a template and then re create the survey using the template, try the export again.effectively it is the original now that you have created it from a template and itshould not re arrange the order.to save it as a template click on the survey thensurvey settings and then Save survey as a template underneath permissions and management.Sharepoint Customiser
July 23rd, 2009 1:03pm

Thanks for the response.Since you say there is no Hotfix Currently, does this mean there will be one createdfor this problem?
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2009 10:14pm

Hi,The product group is aware of the issue and they are currently investigating the issue, but they dont have an estimate for how long it will take. If this is a business critical issue, please contact Microsoft product/customer support services. Thanks for your understanding.Xue-Mei Chang
July 27th, 2009 8:43am

did you try my suggestion tko?Sharepoint Customiser
Free Windows Admin Tool Kit Click here and download it now
July 27th, 2009 2:47pm

Hey skillmaster,I do try your suggestion, and it is still showing the original creation order.If there's no change in surveys forsharepoint' s new version, why MS justdon't release this functionality??This is not the only issue the surveys have.
September 11th, 2009 8:32pm

Is there a fix for this now that a year has passed? I see that it is still not fixed in SharePoint 2010 either. Thanks, LauraLaura Blackmore
Free Windows Admin Tool Kit Click here and download it now
December 14th, 2010 9:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics