Excel Online Limitation - 100K limit on pasting data
Excel Online has a limitation that does not allow you to paste selections larger than 100K. This is extremely limiting as we have users who will sometime need to paste 1000+ rows of data from a CSV file to Excel Online. We migrated from Google Sheets which did not have this limitation. Can anything be done about this limitation?
Our company has been using the 'copy paste function' with no limitation issues until last week. It has taken days of working with Microsoft Support to find out about this limitation. They didn't initially understand this either. I just found this post.
It is still a mystery why we have had no problem since 2015 and suddenly we are unable to copy and paste our 45 line templates that we store in OneDrive and open in Excel Online. Suddenly it is only copying 28 lines of the Excel Template. This has very negatively impacted our productivity. We were sold on 365 because of the ability to work online- 'copy paste' is critical and not a feature that should be limited. Very disappointing.
The only response or work around I saw from MS is to use the client. Surprised to see that as more and more are using Office 365 and not Office 2016 installed on a device.
100k is extremely small. Are there any adverse effects of increasing the size? Everyone cuts and pastes, no changing that behavior, so increasing at least 10 fold would suffice for now