I have been getting an error when I try to export a Contacts list from our SharePoint online environment to excel. It downloads a query file but says "Cannot connect to the server at this time. Changes to your data cannot be saved." when attempting to open it.
I found this as an example but it does not work. https://support.office.com/en-us/article/export-to-excel-from-sharepoint-bfb2ea48-6118-4fa9-abb6-cced9424e5d9?ui=en-US&rs=en-US&ad=US
I have tried with Excel 2016 and Excel Online.