Jul 29 2020 06:29 AM
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."
Jul 29 2020 02:06 PM
Jul 30 2020 12:21 AM
You cannot expect a browser application to have the same functionality as full-fledged desktop client, despite the development trends in the past few years. In particular to Excel, here's a list of major differences: https://support.office.microsoft.com/en-us/article/Differences-between-using-a-workbook-in-the-brows...