Showing posts with label Survey Missing SP2010. Show all posts
Showing posts with label Survey Missing SP2010. Show all posts

13 July, 2012

Export to spreadsheet is missing in survey list-SharePoint 2010

You can use surveys to ask people what they think about issues, how to improve your processes, and many other topics. You can collect the results by using several different types of questions, such as multiple choice, fill-in fields, and even ratings.
As we use Microsoft excel on quite regular basis and very used to with it, we need to see every application in the excel and makes every desperate effort to view it but now the issue is while exporting survey data to excel, we need that option i.e. ‘EXPORT TO SPREADSHEET’ and this seems to be missing.
How to troubleshoot this issue?
I will brief here number of steps by which you can troubleshoot the issue and let me know me know in case of any queries/questions.
·         You should have office application (Office 2010/Office 2007) should be installed on your client machine.
·         Make sure that 'SharePoint Server Enterprise Site Collection features' should be activated at the site collection level.
·         Are you logged in as site collection admin or site owner? What are your permissions on the site? Also, try opening IE in "Run as administrator" mode and see if that makes a difference.
·         Make sure that you have to check the option (i.e. export to spreadsheet) on a actual survey list and not on a web part
·         make sure that on the Survey page, the view on right-hand corner is set to "Overview"
·         On the actual survey list-make sure the proper view is selected inside the web part options: How to check this:
§  Open the survey list in which you are facing the issue
§  Edit page
§  Modify shared web part
§  Under the selected view option
§  Select 'current view' and click on apply
·         Try saving the survey list as a template and create a new one based on the same
·         try to create a access view/standard view by using the following steps:
§  Go to any list and click on create view
§  Copy that URL
§  Go back to the survey list now
§  Settings
§  List settings
§  Copy the url from the browser (i.e. List=)
§  Paste it in the create view (first step)
§  You will get the create view page
Please let me know in case of any further queries. I would be more than happy to help you as well as resolves your issues. Thank you.