[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Sharepoint missing the export survey to excel option

Posted on 2009-12-16
9
Medium Priority
?
2,205 Views
Last Modified: 2012-05-08
Hi,

We are running WSS3 on Windows Server 2003, and after a survey has been created and filled in, I believe there should be an export to excel option in the actions menu (screenshot attached of the actions menu). I am a full site administrator.

We have a survey that has a multiple selections allowed multi-choice question, and sharepoint's default graphical view groups weirdly, so I want to get the raw data into excel, but don't know how when it appears to be missing.

Ideas?
survey-export.png
0
Comment
Question by:visualjazz
  • 6
  • 3
9 Comments
 
LVL 9

Expert Comment

by:dj0rbit
ID: 26069210
0
 

Author Comment

by:visualjazz
ID: 26069226
I should have added I've seen that page, and can confirm that in IIS, on the directory security tab, under authentication and access control "integrated windows authentication" is the only thing ticked.

Should I be looking somewhere else?
0
 
LVL 9

Expert Comment

by:dj0rbit
ID: 26069289
shoot...i've had the exact same problem before when we first implemented WSS. I forgot what we did to fix it but i'll do some more research and get back to you
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 9

Accepted Solution

by:
dj0rbit earned 2000 total points
ID: 26069339
have you tried clearing the browser cache?
are you missing the option for all survey or just this one in particular?
have you asked another admin who has full rights to login to see if he/she getting the same issue
look for disabled add-ons in IE and Excel.

0
 

Author Comment

by:visualjazz
ID: 26069432
Option is missing for all surveys, and I've tried in both IE and firefox, both as my user and another admin (even tried domain admin). Tried on different computers too to make sure it wasn't a browser cache issue.
Will look at addons in a minute
0
 
LVL 9

Expert Comment

by:dj0rbit
ID: 26069451
if the addons doesn't fix the issue, let me check with my other admin tomorrow to see if he remembers and ill get back to you
0
 

Author Comment

by:visualjazz
ID: 26069455
Aha! I have Office 2003 installed at work. I just RDP'd into my computer at home where Office 2007 is installed and logged into our sharepoint site via ISA, and there was the export option!

Works in both IE and Firefox.

So it appears one must have Office 2007 installed, otherwise sharepoint hides the option from you. Very interesting.

Your addon comment led me in the right direction. Thanks!
0
 
LVL 9

Expert Comment

by:dj0rbit
ID: 26069485
that's great, i wish i could travel back in time to see what was the final resolution we did or did we just upgraded everyone to 07. ha

But i'll let you know tomorrow once i talk to my admin.
0
 
LVL 9

Expert Comment

by:dj0rbit
ID: 26075002
Spoke with my admin and he doesn't remember and it was not in our Knowledge Base.

But here's a useful KB that could be of use for the future:

Problem: Internet Explorer crashes (stops responding) when you try to open an Office document in a SharePoint document library

Fix:install the following Hotfix KB938888<---will require a reboot
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question