Forum Discussion
Quick Edit Pasting
CWagner I think the limit is 100 items at a time. I trick I use is to setup a view that shows 100 items and filters out the ones I've already updated.
Quick Edit is the Modern SharePoint name for the Datasheet view in Classic SharePoint
Are you using the latest version of Edge (Chromium based) or the original version? I haven't had issues with the latest version.
- RobElliottApr 28, 2020Silver Contributor
SteveKnutson I regularly use quick edit to add well over 100 items at a time using Chrome. However I try to keep it below 300 as above that I find the page can (though doesn't always) stop responding in the initial paste phase before it adds each item.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- SteveKnutsonApr 28, 2020MVP
RobElliott thanks Rob, I hadn't tried more for quite a long time. Old habits!
- CWagnerApr 28, 2020Copper Contributor
SteveKnutson yes I believe I have the latest version of Edge. My frustration mainly is that I think the limit is technically 100, in that if you go over 100 you get an error message. But really you can do more than that. I will keep a separate duplicate tab open with the same view I am using to update, and with more than 100, I will get the error message with the red exclamation next to each item, but if I wait and monitor refreshing the other tab, I can watch the items still update in spite of the error message. I think I have done at least 1,000 successfully this way...
- SteveKnutsonApr 28, 2020MVP
CWagner I had noticed that. I'll give it a try next time I'm doing a large bulk update. Thanks for the tip.