SharePoint - Excel Online - Edit in Excel and Edit in Browser multiple users

Question

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.

Answer 1

Here is the Microsoft article regarding co-authoring

https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104?ui=en-US&rs=en-US&ad=US

When asked "Why can't I see other people's selections?" in the Frequently Asked Questions, the answer is "only if you and other people are using Excel 2016 for Office 365 subscribers, or Excel Online."

Earlier versions of Excel, if I am not remembering, would automatically "Check-out" the document when it was opened on the client-side, rendering it unavailable until it was checked back in.