So we have a SharePoint Online document library set to open documents in the client applications
When opening the document using Chrome, a copy of the file is downloaded, saved to a local directory and opened using the Client Application. Users are only able to make changes and save the changes to the local copy. All is good with the world.
Clicking on "Edit Workbook", we get the connecting to the server error above.
My understanding is that IE is downloading a temporary copy of the file which inherits the permission from the SPO document library. Most users don't have write access to the library.
The easiest workaround is to just manually save a local copy of the file, ie: File > Save As >...
Question: Is there a setting I can change to force IE to download a copy of the file instead of opening a temporary copy?
It's been suggested I use:
but we have 1000s files.