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

25 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?

Sandip said...

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

Sandip said...

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

Unknown 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

Anonymous 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 ?

Madhu Balan said...

Good job! Fruitful article. I like this very much. It is very useful for my research. It shows your interest in this topic very well. I hope you will post some more information about the software. Please keep sharing!!
Java Training in Chennai
Java Training in Coimbatore
Java Training in Bangalore

chandhran said...

Such an amazing blog your content is so good..
Air Hostess Training Institute in chennai
Air hostess Training Institute in Bangalore
Air hostess Training Fees in Mumbai
Air Hostess Training in Chennai
Aviation courses in Bangalore
Air Hostess Training in Chennai
Air Hostess Training Institute in chennai
Aviation Courses in Chennai
Aviation Institute in Bangalore
Air Hostess Course in Chennai

Kayal said...


This article is increasing the interest to learn more about this topic. Continue the sharing your new updates, regularly for my future.
Linux Training in Chennai
Learn Linux
Spark Training in Chennai
Oracle Training in Chennai
JMeter Training in Chennai
Appium Training in Chennai
Power BI Training in Chennai
Embedded System Course Chennai
Pega Training in Chennai
Linux Training in Thiruvanmiyur

silakarim said...


Thanks for your valuable content, it is easy to understand and follow.keep update more information.
Tally Course in Velachery
Tally Course in Tambaram
Tally Course in Anna nagar
Tally Course in OMR
Tally Course in Adyar
Tally Course in Thiruvanmiyur
Tally Course in Porur
Tally Course in T Nagar
Tally Course in Vadapalani

rinjuesther said...

awesome blog...keep update...
clinical sas training in chennai
clinical sas training fees
clinical sas training in vadapalani
clinical sas training in Guindy
clinical sas training in Thiruvanmiyur
SAS Training in Chennai
Spring Training in Chennai
LoadRunner Training in Chennai
QTP Training in Chennai
javascript training in chennai

Softgen Infotech said...

Wonderful thanks for sharing an amazing idea. keep it...

Learn SAP Training from the Industry Experts we bridge the gap between the need of the industry. Softgen Infotech provide the Best SAP Training with 100% Placement Assistance. Book a Free Demo Today.

Softgen Infotech said...

I am happy for sharing on this blog its awesome blog I really impressed. thanks for sharing.

Looking for Software Training in Bangalore , learn from Softgen Infotech Software Courses on online training and classroom training. Join today!

mytechtimepro said...

You should be a part of a contest for one of the greatest sites online. Technology I will highly recommend this website!

merlin said...

It is really a great work and the way in which u r sharing the knowledge is excellent.Thanks for your informative article.

Selenium Training in chennai | Selenium Training in annanagar | Selenium Training in omr | Selenium Training in porur | Selenium Training in tambaram | Selenium Training in velachery

subha said...

Thanks for sharing the wonderful post! very nice to seethis blog kee it up
Ai & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai

360digitmgas said...

I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful. data science training in coimbatore

Best Training Institute said...

Information was good,i like your post.Looking forward for more on this topic.
Sharepoint Admin training in bangalore

Hi Every One said...

I expected to thank you for this in your appreciating ensnare!! I particularly participating in all little piece of it I have you ever bookmarked to take a gander at conveyed stuff you articulate. Hotspot Shield Crack

The Blogger Worlds said...

Imagenomic Portraiture enables us to accomplish excellence in portrait retouching by removing the arduous labour of choosing masking and pixel-by-pixel treatments.. Portraiture Plugin For Photoshop CS6 Crack

The Blogger Worlds said...

I comprehend this is one of the main course for me. Moreover, I'm energetic focusing on your article. at any rate need to publication upon a couple of standard matters, the web page style is unmodified; the articles are safe. much gratitude to you for the enormous measure of genuine and appropriate unequivocal. Birthday Wishes For Baby Girl 3rd Birthday

Hurrain said...

Thanks for writing such a great article! It has posts that are great and helpful. Keep it up.
ocean of game