Forum Discussion
Can't paste mutiple rows into Quick Edit since recent changes
staregirl and Andrew Thornton-Smith - Big news! I submitted a support ticket to Microsoft yesterday. They were unable to replicate the problem in their test env, but had my try the "SharePoint Classic Experience." It took a bit of navigation for me to get the Quick Edit mode worksheet in the SharePoint Classic Experience, but... great news! I was able to copy and paste many rows at a time from Excel to my SharePoint list. Yay! So that is the work-around for now I assume, until it is fixed in the SharePoint modern experience.
- Tong56Aug 30, 2021Copper Contributor
I can only copy 5 or less rows from excel to sharepoint 2019 datasheet without problem. When I copy 20 rows or more, it replicate twice in the target datasheet. The browser I use is the latest version of Edge an Chrome. The turn around is to user the old browser IE11 to do the copy and past. Not sure what happen? Ulhas Morbale