Quick Edit Pasting

%3CLINGO-SUB%20id%3D%22lingo-sub-1328779%22%20slang%3D%22en-US%22%3EQuick%20Edit%20Pasting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1328779%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20explain%20what%20the%20actual%20limits%20are%20and%20what%20the%20best%20browser%20to%20use%20is%20if%20I%20want%20to%20paste%20data%20into%20a%20Sharepoint%20Online%20list%20using%20a%20quick%20edit%20view%3F%20I%20see%20conflicting%20information%20as%20far%20as%20what%20the%20limits%20are.%20Also%2C%20it%20frustrates%20me%20that%20it%20will%20return%20the%20%22Unable%20to%20Communicate%20with%20Server%22%20error%2C%20when%20in%20fact%20the%20updates%20will%20work%20if%20you%20just%20wait%20(but%20the%20error%20never%20message%20never%20goes%20away).%20If%20I%20want%20to%20work%20with%20large%20lists%20in%20SP%20Online%2C%20here%20are%20my%20questions%3A%3C%2FP%3E%3COL%3E%3CLI%3EIs%20there%20a%20limit%20on%20how%20many%20rows%20of%20data%20can%20be%20updated%20in%20a%20Quick%20Edit%20or%20Datasheet%20view%3F%3C%2FLI%3E%3CLI%3EIs%20there%20a%20difference%20in%20a%20quick%20edit%20view%20vs%20a%20datasheet%20view%3F%20I%20feel%20like%20I%20see%20both%20of%20these%20names%20in%20different%20places.%20Is%20there%20a%20difference%3F%20Does%20it%20just%20depend%20on%20classic%20vs%20modern%20experience%3F%3C%2FLI%3E%3CLI%3EIs%20one%20browser%20better%20to%20use%20than%20another%3F%20It%20seems%20like%20Edge%20has%20some%20things%20that%20don't%20work%20when%20they%20do%20work%20in%20Chrome%20or%20IE.%3C%2FLI%3E%3C%2FOL%3E%3CP%3EIf%20anyone%20could%20provide%20some%20clarity%20on%20these%20questions%2C%20I%20would%20greatly%20appreciate%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1328779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1331004%22%20slang%3D%22en-US%22%3ERe%3A%20Quick%20Edit%20Pasting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1331004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F261288%22%20target%3D%22_blank%22%3E%40CWagner%3C%2FA%3E%26nbsp%3BI%20think%20the%20limit%20is%20100%20items%20at%20a%20time.%20I%20trick%20I%20use%20is%20to%20setup%20a%20view%20that%20shows%20100%20items%20and%20filters%20out%20the%20ones%20I've%20already%20updated.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EQuick%20Edit%20is%20the%20Modern%20SharePoint%20name%20for%20the%20Datasheet%20view%20in%20Classic%20SharePoint%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20using%20the%20latest%20version%20of%20Edge%20(Chromium%20based)%20or%20the%20original%20version%3F%20I%20haven't%20had%20issues%20with%20the%20latest%20version.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1344156%22%20slang%3D%22en-US%22%3ERe%3A%20Quick%20Edit%20Pasting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1344156%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F43161%22%20target%3D%22_blank%22%3E%40Steve%20Knutson%3C%2FA%3E%26nbsp%3Byes%20I%20believe%20I%20have%20the%20latest%20version%20of%20Edge.%20My%20frustration%20mainly%20is%20that%20I%20think%20the%20limit%20is%26nbsp%3B%3CEM%3Etechnically%26nbsp%3B%3C%2FEM%3E100%2C%20in%20that%20if%20you%20go%20over%20100%20you%20get%20an%20error%20message.%20But%20really%20you%20can%20do%20more%20than%20that.%20I%20will%20keep%20a%20separate%20duplicate%20tab%20open%20with%20the%20same%20view%20I%20am%20using%20to%20update%2C%20and%20with%20more%20than%20100%2C%20I%20will%20get%20the%20error%20message%20with%20the%20red%20exclamation%20next%20to%20each%20item%2C%20but%20if%20I%20wait%20and%20monitor%20refreshing%20the%20other%20tab%2C%20I%20can%20watch%20the%20items%20still%20update%20in%20spite%20of%20the%20error%20message.%20I%20think%20I%20have%20done%20at%20least%201%2C000%20successfully%20this%20way...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1345177%22%20slang%3D%22en-US%22%3ERe%3A%20Quick%20Edit%20Pasting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1345177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3Bthanks%20Rob%2C%20I%20hadn't%20tried%20more%20for%20quite%20a%20long%20time.%20Old%20habits!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1344545%22%20slang%3D%22en-US%22%3ERe%3A%20Quick%20Edit%20Pasting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1344545%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F43161%22%20target%3D%22_blank%22%3E%40Steve%20Knutson%3C%2FA%3E%26nbsp%3BI%20regularly%20use%20quick%20edit%20to%20add%20well%20over%20100%20items%20at%20a%20time%20using%20Chrome.%20However%20I%20try%20to%20keep%20it%20below%20300%20as%20above%20that%20I%20find%20the%20page%20can%20(though%20doesn't%20always)%20stop%20responding%20in%20the%20initial%20paste%20phase%20before%20it%20adds%20each%20item.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Can someone explain what the actual limits are and what the best browser to use is if I want to paste data into a Sharepoint Online list using a quick edit view? I see conflicting information as far as what the limits are. Also, it frustrates me that it will return the "Unable to Communicate with Server" error, when in fact the updates will work if you just wait (but the error never message never goes away). If I want to work with large lists in SP Online, here are my questions:

  1. Is there a limit on how many rows of data can be updated in a Quick Edit or Datasheet view?
  2. Is there a difference in a quick edit view vs a datasheet view? I feel like I see both of these names in different places. Is there a difference? Does it just depend on classic vs modern experience?
  3. Is one browser better to use than another? It seems like Edge has some things that don't work when they do work in Chrome or IE.

If anyone could provide some clarity on these questions, I would greatly appreciate it.

5 Replies
Highlighted

@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. 

Highlighted

@Steve Knutson 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...

Highlighted

@Steve Knutson 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

Highlighted

@Rob Elliott thanks Rob, I hadn't tried more for quite a long time. Old habits!

Highlighted

@CWagner I had noticed that. I'll give it a try next time I'm doing a large bulk update. Thanks for the tip.