Friday, July 07, 2006

Survey export to excel problems

Ok so what do when you have the following error : 'Sharepoint "Results to spreadsheet" results in Error: Unable to open ........ The Internet site reports that the item you requested could not be found. (HTTP/1.0 404)' Check whether the user is accessing the site via an anonymous + windows intergrated authentication or just pure windows integrated. Excel tries to access the site anonymously and therefore cannot open the survey. The case which I had this problem was one where we have a portal with teamsites both accessible as anonymous as windows intergrated. We use two urls for this scenario since Sharepoint Portal does not come with a sign-in button so defaultwise this url is only windows integrated. The other url is both windows intergrated and anonymous. Most users use this url to access their site and therefore had this problem. I had a hard time figuring this one out! :)

9 comments:

Anonymous said...

I'm getting this error when linking from Excel. What steps did you take??

Anonymous said...

Here's a twist on the issue I wonder if anyone can help me with... i am trying to copy/paste information from excel into a sharepoint calendar, but the paste function does not work. This does not happen all the time and I've been doing this for almost a year w/o issue. I've been advised it could be some VB code in XL and that I should manually input data into the cells... yeah well, that doesn't work either... Anybody? Anybody? Respond to ch3rry5@yahoo.com Thanks

Robin Meuré said...

Why would even want to copy/paste data from excel into a sharepoint calendar? You know you can use Outlook calendars with Sharepoint calendars?

Could you give more detail in what you are trying to achieve?

san said...

Hello friends...
i am getting same error messenge when i am trying to export sharepoint List to spredsheet.can anybady help.

san said...

now am able to export sharepoint list to spreadsheet.i have installl office 2003,previously i was using office xp 2002 sp2.

Snehil said...

Hi

I am not able to export to excel from sharepoint. I am getting this error "Cannot get the list schema column property from the Sharepoint List".

Did anyone face this problem?

Thanks

Anonymous said...

Hi Snehil,

This is because of a 'date' type column in the list. Convert it to 'single line of text' and immediately convert it back to 'date' type. Surprisingly, export to excel will work just fine.

-Srinivas

Ted said...

An issue that I've found is that people fields that are marked to contain multiple people also will not export. The entire field doesn't show up in the spreadsheet. The only way that I have found out how to get around this is to change the field to allow only one person.

Ravi Shankar Ambati said...

I am not getting "Export to Excel" optoin on SharePoint. Can some one help me enable that ?