This SharePoint tutorial explains how to fix an error “Excel cannot connect to the SharePoint list” which usually comes when you export the list to a spreadsheet.
Also sometimes you will get the error message as Cannot connect to the server at this time. Changes to your 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.
You may like the following SharePoint tutorials:
- Configure Excel Service Application in SharePoint 2013/2016
- Publishing and Synchronizing Excel tables to SharePoint 2013/2016/Online Lists using Excel Add-in
- Power Automate update SharePoint list item
- Power Automate update SharePoint list increment integer field
- How to delete all items from SharePoint list
- Power Automate get events into excel
- Power Automate Get Data from Excel on SharePoint
- Power Automate Forms to Excel
- Web parts maintenance page: if you have permission, you can use this page to temporarily close web parts or remove personal settings
This is how we can fix errors Excel cannot connect to the SharePoint list.
I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SPGuides.com