In this post we will discuss how to resolve the issue "Excel cannot connect to the SharePoint list" which usually comes when you export list to spreadsheet. Also you can check out my previous posts on:
Also sometime you will get the error message as: Cannot connect to the server at this time. Changes to you Data cannot be saved.
You can try the solution below but I am not sure it is the best solution.
- Open Internet Explorer
- Go to Tools -> Options then go to Advanced Settings.
- Scroll and go to the Security Section.
- By default "Check for publisher's certificate revocation" option is checked. Uncheck that and click on OK as shown in the fig below:
- Now close the browser and open the SharePoint site in a new browser window. The error should not come now.