Sep 05 2017 02:27 AM
Hi everyone,
Since this week we are not able to copy and paste from Excel sheet to SharePoint Online List, my customer was used to copy and paste many lines of Excel to a List in one step but now it's not working anymore, we tried on many computers and different navigators same issue.
Someone have the same problem ?
Sep 05 2017 04:59 AM
Hello Sylvain,
Have you tried IE? According to my experience this only works in IE.
Bart
Sep 05 2017 08:42 AM
Sep 05 2017 09:20 AM
Has the view in your list or the order of the columns in your spreadsheet changed? Could it be that the data simply doesn't fit any more?
Do you get any error messages or does the data simply not appear on paste?
Sep 29 2017 06:17 AM
I don't get any error messages, the paste just don't work
Sep 29 2017 06:26 AM
Thank you ! It's working with IE but strange i'm sure it did work with others web browsers
Dec 09 2019 05:09 AM
I got similar problem and its due to many inforamtion pasted in previous operation of copy paste were not validated as per rules set in Sharepoint List. I have refreshed the page by going in view mode and then coming back to edit mode and it started working for me.
Feb 11 2021 02:43 PM
@Sylvain Jacquemard I have the same problem. I have a SharePoint list on a Mac using the Edge, Chrome or Safari browsers and have been able to copy and paste multiple columns from Excel to that list (using Grid View of course) every week for many months. Until Now.
I am not going to use IE!
May 17 2022 03:23 AM
Jun 06 2022 08:14 AM
Also looking for help on this issue. IE officially no longer works, and apparently there are no solutions for some key functionality like this and opening in Windows Explorer?
Jun 06 2022 08:22 AM - edited Jun 06 2022 08:25 AM
Hi there! Just last week my team discovered that you can add the Internet Explorer mode onto Edge and when you work in this mode cut and paste works.
To add the IE Mode, go to Settings in Edge and in the search put in Internet Explorer mode. Scroll down and you will see the Internet Explorer mode option and you can slide it on. Once on, you should see an icon that looks like a little page with an “e” on it on your Edge Browser on the left upper corner once you close the browser and reopen it. Hope that works for you as it did for me!
Apr 26 2023 03:51 PM
Cut and Paste should mean exactly that! It is absolutely RIDICULOUS and UNACCEPTABLE that one of the most fundamental, primary functions like Cut and Paste doesn't work? Most of the time it won't copy, many times it pastes so previous value that was used hours ago, or it just sits there and does nothing. WHY ON EARTH WOULD THIS BE REMOVED? Someone must think this is funny, it's not, it's infuriating. Why keep making the products you offer less and less functional? We're asking simple questions and the answers we're getting back are like you're completely oblivious. Here's my Feedback: Fix Cut and Paste and stop playing games, we have work to do. Look how long this thread has been going on and it hasn't given you enough reason to fix it yet? Who's making these decisions, maybe it's time you hire people that don't dumb-down their products or make the harder to use everyday
Aug 08 2023 02:35 AM - edited Aug 08 2023 02:47 AM
I definitely hear what you are saying. It took me several failed attempts with the Modern version and deep breaths before I gave Classic a try.
I was able to paste from Excel to a SharePoint Online list in Classic view. And once in Classic, it took a moment to figure out I had to click on the pencil icon to get the copied content to paste correctly in the list.
At this point just grateful it can be done. I have a decade of content to paste from an Access table!