We have a E3 Office subscription. We moved to Office 365 and still have an on prem 2013 Foundation Sharepoint farm. However when a user with O365 goes to SharePoint 2013 and exports a list to excel they get prompted for credentials, once signed in, it gives them the error:
"Cannot connect to the server at this time. Changes to your data cannot be saved"
Exporting work fine with office 2013.
I have added the site to the trusted sites. Removed Security feature Check for publisher's certificate revocation.
Looking for other suggestions.