asked on

Export Sharepoint Survey Results

I have a survey that I created in Sharepoint on a Small Business Server installation. I have made the survey and have results. I have the option to export to excel. I try that option and it does not show the results of each question. For example if I have three filled out surveys (25 questions a piece) the only results that show are like this;
ID      Created By
1      ***
2      ***
3      ***

I would like to see questions numbers and answers etc.

Thank you for any help!

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Hello,

do you have sufficient access rights to view the survey results?

cheers, teylyn

mobanker

ASKER

I was set as the web designer, so I changed it to site administrator. I still have the same results.

Thank you,

Mobanker

ruslanin

Before export to excel, when you click Show all responses, can you see columns with all questions ?

tomappu

Its also depend on the version on Excel you use, Its does not work with Office 2003.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

@tomappu

pardon?

Can you substantiate that? I've been happily exporting surveys to Excel 2003 for years. No problems, as long as I can access the survey results in Sharepoint.

cheers, teylyn

ASKER CERTIFIED SOLUTION

tomappu

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mobanker

ASKER

Yes, I can see the results correctly when I click on show results. I am using 2003 Excel, but I have a 2010 machine available. I will try that and repost results.

Thanks!

mobanker

ASKER

I opened it with Excel 2010 and was able to view the full results without issue!

Thank you all for your help!