I have created an excel document in a document library. If all users edit via excel online that has no problem.
But If the user1 Edits the excel file in "Edit in Excel"(Open in Microsoft Excel) and the other user2 Edits in Browser(Excel Online) then both cant edit the file at the same time.
If user2 tries to edit the file in excel online when user1 already edited it in excel then gets a warning -
Unfortunately, the workbook needs to be closed on or checked in before you can edit it. If everyone uses Excel Online, you can work on it at the same time.
I am wondering if there is a way for user1 to edit files in Microsoft Excel and user2 to edit on Excel online at the same time.
I tried to find information on this but it says - multiple users can edit only online. I want to find out if there is any other way.