Export Sharepoint Survey Results

mobanker
mobanker used Ask the Experts™
on
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!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

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

cheers, teylyn

Author

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

Thank you,

Mobanker

Commented:
Before export to excel, when you click Show all responses, can you see columns with all questions ?
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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

Most Valuable Expert 2011
Awarded 2010

Commented:
@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
Commented:
Not all survey results are show in Excel 2003. Faced some issue like that. Contacted MS they have asked us to upgrade to Excel 2007. Because some features are not available on 2003.

Author

Commented:
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!

Author

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

Thank you all for your help!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial