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.
Excel cannot connect to the SharePoint list
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.
This is how we can fix errors Excel cannot connect to the SharePoint list.
You may also like
After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (9 times). I have also worked in companies like HP, TCS, KPIT, etc.