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.
When opening the document using IE, it is opened using the Client Application but this seems to be connected to the online copy.
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.
Question: Is there a setting I can change to force IE to download a copy of the file instead of opening a temporary copy?
but we have 1000s files.
Try checking in the Document Library Settings>Advanced Settings>Opening Documents in the browser. Does changing the Opening Documents in the Browser help?
Could browser settings be the issue otherwise? Try to compare IE with Chrome.
Not the answer you're looking for? Browse other questions tagged sharepoint-online internet-explorer or ask your own question.
How does co-editing a Sharepoint Excel Online document work?