visualjazz
asked on
Sharepoint missing the export survey to excel option
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
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
try the following link: http://www.eggheadcafe.com
ASKER
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?
Should I be looking somewhere else?
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Will look at addons in a minute
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
ASKER
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!
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!
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.
But i'll let you know tomorrow once i talk to my admin.
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
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