Exporting Sharepoint survey results
I have a Sharepoint survey which has 48 responses and I am trying to analyse the results. To do this, I would like to export the results to Excel. However, what I am finding is that it is not exporting the responses to any questions that used a rating scale. Can anybody please help with this?
July 23rd, 2009 5:02pm

What exactly you mean by rating scale, is that part of questions? or are you allowing user to rate the survey, I am confused please explain, so that one can help you easily.
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2009 5:27pm

What version of SharePoint are you running? SharePoint Services 2.0 always had an issue with this but was resolved with version 3.0SharePoint Administrator | SharePoint Fan www.davepyett.wordpress.com - Follow me on twitter: twitter.com/dpyett
July 23rd, 2009 6:31pm

I am asking a question in the survey that has a question type of rating scale. Therefore, I am asking the respondent to score our service on a rating scale of 1 to 10. Does that make sense?
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2009 6:34pm

Hi noelgarry, Dave is right. If you are using Moss 2007 or WSS 3.0, it will display the rating scale option in the spreadsheet. If you are using Office SharePoint Portal Server 2003 or Windows SharePoint Services 2.0, the survey result will not be exported to spreadsheet ifthe answer to a question uses a rating scale. Microsoft just released a KB article for this issue, please refer to: http://support.microsoft.com/default.aspx/kb/889591 Hope this helps. Lu Zou
July 27th, 2009 6:44am

Hello,could you tell me please, which version of Excel must I have, If I want to use a rating scale in my survey and export it to excel. Now, we usedexcel 2003 and we have problem with it. Do I have to use excel 2007 ???Thank you...Vasek
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2009 2:15pm

HELP! I am using MOSS 2007 with excel 2007 and exporting gives column data for all BUT the rating scale values (1 - 5 which show up in the survey, but no values show up in the excel export in that column). Anybody have a fix? This is a bug from my perspective and I've not found any help on the web elsewhere!! thanks anyone...everyone....somebody... vinvin
February 18th, 2011 11:15pm

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

Other recent topics Other recent topics