Limitations of OneDrive Excel and Sharepoint Excel

Question

Hi All,
Thanks in advance, we have a query from one of our directors that OneDrive Excel(Office365) has below mentioned limitations:
Lost updates due to concurrency
Updates done by one person not reflected to othersr.
Too much time in opening the file when multiple people try to access it (even with see your own view or everyone's view)
Local sync of onedrive folder

Is there anyway where we can address these issues?? Or would Excel on Sharepoint or Teams be better??
Their requirement is "updated by multiple people (~20 concurrent users) at the same time in OneDrive Excel sheets and view in different pivots."

Answer 1

OneDrive is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
https://techcommunity.microsoft.com/t5/onedrive-for-business/bd-p/OneDriveforBusiness
https://answers.microsoft.com/it-it/msoffice/forum/msoffice_onedrivefb

--please don't forget to Accept as answer if the reply is helpful--

Answer 2

Information about limitations and requirements for Excel on the web and co-authoring are at https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104#PickTab=Windows.

The limitation for number of users is "classroom sized", about 30 - 50 people in a document at the same time.

Answer 3

For excel co-authoring, OneDrive Excel SharePoint Excel and Teams Excel are all same.

For these issues you mentioned, you could refer to the article Trevor provided: collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring