One interesting issue that i came accross today .
The user had created a list .
When he selects list Actions => Export to spreadsheet
Excel opens up and Displays 'Security' dialog box by giving the option of 'ENABLE' and 'DISABLE'.
User Clicks on the Enable button then we get the 'Import Data' dialog box , and then he clicks OK.
As soon as he clicks the OK button an error message comes up Excel Cannot Connect to SharePoint List or at times it may also happen that you may receive the following error : Cannot connect to the server at this time. Changes to you Data cannot be saved.
I researched and found a solution to the issue shared by one of my friend
http://sharepointknowledgebase.blogspot.in/2011/06/excel-cannot-connect-to-sharepoint-list.html
It says :
Generally we start our troubleshooting from the SharePoint side as what is wrong with my SharePoint site, Is there any problem in the SharePoint list, Does the Office which is installed on the machine is causing the problem ? Is there any site collection feature turned off? Is there any problem in the SP-Database? Problem with the IIS? so things are there by which we can think off but don't waste your time in doing all these things as I have done all these things and the resolution is quite simple which you can implement without any help.
1. Open the Internet Explorer
2. Tools
3. Internet Options
4. Advanced Settings
5. Scroll downwards and reach towards the section named as "Security"
6. CHECK FOR SERVER CERTIFICATE REVOCATION--which is by default checked
7. Unchecked it
8. Apply and Ok
9. Close all the internet explorers (IE) and open your SharePoint site in a new IE i.e. Browser/Explorer
10. You should be able to export the spreadsheet without any problems/issues.
Thanks to Amol Ghuge .
The user had created a list .
When he selects list Actions => Export to spreadsheet
Excel opens up and Displays 'Security' dialog box by giving the option of 'ENABLE' and 'DISABLE'.
User Clicks on the Enable button then we get the 'Import Data' dialog box , and then he clicks OK.
As soon as he clicks the OK button an error message comes up Excel Cannot Connect to SharePoint List or at times it may also happen that you may receive the following error : Cannot connect to the server at this time. Changes to you Data cannot be saved.
I researched and found a solution to the issue shared by one of my friend
http://sharepointknowledgebase.blogspot.in/2011/06/excel-cannot-connect-to-sharepoint-list.html
It says :
Generally we start our troubleshooting from the SharePoint side as what is wrong with my SharePoint site, Is there any problem in the SharePoint list, Does the Office which is installed on the machine is causing the problem ? Is there any site collection feature turned off? Is there any problem in the SP-Database? Problem with the IIS? so things are there by which we can think off but don't waste your time in doing all these things as I have done all these things and the resolution is quite simple which you can implement without any help.
1. Open the Internet Explorer
2. Tools
3. Internet Options
4. Advanced Settings
5. Scroll downwards and reach towards the section named as "Security"
6. CHECK FOR SERVER CERTIFICATE REVOCATION--which is by default checked
7. Unchecked it
8. Apply and Ok
9. Close all the internet explorers (IE) and open your SharePoint site in a new IE i.e. Browser/Explorer
10. You should be able to export the spreadsheet without any problems/issues.
Thanks to Amol Ghuge .
it's not working for me
ReplyDeletePlease provide the complete details of the error . if you can send some screen shots to my mail will be good to understand the issue .
Deletemy mail sushant.khambekar@gmail.com
It works! Thanks.
ReplyDeleteWith out changing the IE settings, it worked for me on sharepoint 2013 site, but it is not working on sharepoint 2010 sharepoint list which is having 32000 records..!
ReplyDeleteAmazing , it worked for me
ReplyDeletedidnt work for me
ReplyDeleteThank you for your informative article..
ReplyDeleteGraphic designer jobs in bangalore