Can't paste mutiple rows into Quick Edit since recent changes

%3CLINGO-SUB%20id%3D%22lingo-sub-788054%22%20slang%3D%22en-US%22%3ECan't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788054%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20having%20problems%20pasting%20into%20Quick%20Edit.%20It%20just...%20doesn't%20work%3F%20If%20I%20try%20to%20paste%20more%20than%20say%2010%20rows%2C%20the%20screen%20whites%20out%20with%20the%20'Loading'%20wheel%20going%20and%20no%20matter%20how%20long%20we%20wait%2C%20it%20simply%20hangs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20across%20two%20tenants%20and%20several%20users.%20Anyone%20got%20any%20ideas%3F%20It's%20really%20getting%20in%20the%20way%20of%20things.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20paste%20one%20row%20at%20a%20time%2C%20but%20even%20that%20can%20be%20patchy%2C%20sometimes%20it%20only%20picks%20up%20the%20first%20one%20or%20two%20fields%20and%20then%20we%20get%20the%20little%20blue%20loading%20wheel%20in%20the%20first%20cell%20in%20the%20row.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhenever%20either%20of%20these%20things%20happens%2C%20the%20Exit%20Quick%20Edit%20link%20is%20unresponsive%20and%20we%20have%20to%20exit%20all%20the%20way%20out%20to%20another%20page%2C%20go%20back%20in%20and%20try%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScreen%20grab%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125604iF1B80BB73F43585B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Loading%20Hang%20Snip.PNG%22%20title%3D%22Loading%20Hang%20Snip.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-788054%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-790461%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790461%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387374%22%20target%3D%22_blank%22%3E%40staregirl%3C%2FA%3E%26nbsp%3BI'm%20experiencing%20the%20exact%20same%20thing%2C%20and%20it%20is%20a%20major%20problem%20for%20me%2C%20too.%20When%20I%20cut%20and%20paste%20rows%20from%20Excel%20into%20the%20Quick%20Edit%20mode%20worksheet%20of%20a%20SharePoint%20list%2C%20normally%20I%20can%20do%20dozens%20of%20rows%20together%20at%20a%20time.%20As%20of%20yesterday%2C%20no%20more%20than%205%20or%20so%20rows.%20I've%20tried%20everything%20to%20try%20to%20coax%20it%20back%20into%20working%20-%20even%20re-created%20my%20list%20with%20less%20fields%20than%20desired%2C%20and%20hardly%20any%20lookup%20fields.%20I%20sure%20hope%20we%20get%20some%20SME%20attention%20to%20this%20and%20it%20gets%20fixed!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790469%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790469%22%20slang%3D%22en-US%22%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EOh%2C%20it's%20so%20nice%20to%20know%20we're%20not%20alone.%3CBR%20%2F%3E%3CBR%20%2F%3E*jumps%20up%20and%20down*%20Hey!%20anyone%20know%20what's%20happening%3F%20I'm%20now%20looking%20at%20patching%20data%20from%20PowerApps%20to%20SharePoint%20lists%20because%20I%20can't%20copy%2Fpaste%20and%20that's%20more%20workaround%20than%20I'd%20like...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793606%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793606%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387374%22%20target%3D%22_blank%22%3E%40staregirl%3C%2FA%3E%26nbsp%3BSigh%2C%20me%20too.%20Cant%20paste%20any%20data%20in.%20Any%20ideas%3F%3C%2FP%3E%3CP%3ETried%20all%20the%20usual%20suspects%2C%20different%20browsers%2C%20new%20list%2C%20simple%20data%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20a%20call%20to%20Microsoft%20been%20logged%20by%20any%20chance%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndrew%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793939%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793939%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387374%22%20target%3D%22_blank%22%3E%40staregirl%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5761%22%20target%3D%22_blank%22%3E%40Andrew%20Thornton-Smith%3C%2FA%3E%26nbsp%3B-%20Big%20news!%20I%20submitted%20a%20support%20ticket%20to%20Microsoft%20yesterday.%20They%20were%20unable%20to%20replicate%20the%20problem%20in%20their%20test%20env%2C%20but%20had%20my%20try%20the%20%22SharePoint%20Classic%20Experience.%22%20It%20took%20a%20bit%20of%20navigation%20for%20me%20to%20%3CSTRONG%3Eget%20the%20Quick%20Edit%20mode%20worksheet%20in%20the%20SharePoint%20Classic%20Experience%2C%20but...%20great%20news!%20I%20was%20able%20to%20copy%20and%20paste%20many%20rows%20at%20a%20time%3C%2FSTRONG%3Efrom%20Excel%20to%20my%20SharePoint%20list.%20Yay!%20So%20that%20is%20the%20work-around%20for%20now%20I%20assume%2C%20until%20it%20is%20fixed%20in%20the%20SharePoint%20modern%20experience.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-794068%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794068%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388064%22%20target%3D%22_blank%22%3E%40Clodine%3C%2FA%3E%26nbsp%3BAh%20thats%20great%2C%20I%20will%20give%20that%20a%20go%20tomorrow%20morning.%3CBR%20%2F%3EThank%20you%20for%20the%20info!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-795568%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795568%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388064%22%20target%3D%22_blank%22%3E%40Clodine%3C%2FA%3Ethat's%20great%2C%20I'll%20have%20a%20go%20now%20and%20hopefully%20we%20can%20stagger%20on%20while%20they%20look%20into%20it.%20Thanks%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-801467%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-801467%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20found%20that%20workaround%2C%20but%20not%20a%20good%20option%20for%20me.%26nbsp%3B%20tried%20list%20settings%20%26gt%3B%20advanced%20settings%20%26gt%3B%20list%20experience%20%26gt%3B%20classic%20experience%20to%20get%20closer%20to%20a%20workable%20option%2C%20but%20doesn't%20seem%20to%20do%20anything.%26nbsp%3B%20has%20anyone%20used%20that%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388064%22%20target%3D%22_blank%22%3E%40Clodine%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-801475%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-801475%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388255%22%20target%3D%22_blank%22%3E%40D_W-1%3C%2FA%3E%26nbsp%3BNo%2C%20didn't%20try%20that%20as%20the%20basic%20work-around%20works%20well%20enough%20for%20me%20for%20now.%20I%20just%20switch%20over%20briefly%20to%20Classic%20mode%20for%20my%20%22bulk%20copy-paste%22%20and%20then%20go%20back%20to%20modern.%20Good%20luck!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-830304%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830304%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387374%22%20target%3D%22_blank%22%3E%40staregirl%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5761%22%20target%3D%22_blank%22%3E%40Andrew%20Thornton-Smith%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388255%22%20target%3D%22_blank%22%3E%40D_W-1%3C%2FA%3E%26nbsp%3B-%20the%20fix%20is%20on%20the%20way%3B%20I%20think%20my%20testing%20helped%20identify%20the%20cause.%20I'm%20in%20a%20targeted%20release%20group%20for%20my%20company%2C%20and%20just%20tested.%20I%20was%20able%20to%20copy-and-paste%20well%20over%20100%20rows%20from%20an%20Excel%20file%20into%20a%20SharePoint%20list%20using%20Quick%20Edit%20Mode%20in%20Modern%20experience.%20I%20HAVE%20NO%20IDEA%20THE%20PUSH%2FRELEASE%20SCHEDULE%20FOR%20THIS%2C%20so%20the%20fix%20may%20or%20may%20not%20be%20there%20for%20you%20(and%20possibly%20some%20of%20my%20colleagues)%20for%20a%20while.%20I'd%20recommend%20you%20periodically%20test%2C%20esp.%20after%20the%20next%202-3%20SharePoint%20release%20updates.%20Good%20luck!%20And%20bye%20bye.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1360563%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20paste%20mutiple%20rows%20into%20Quick%20Edit%20since%20recent%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1360563%22%20slang%3D%22en-US%22%3EThis%20solution%20of%20copying%20from%20excel%20to%20quick%20edit%20worked%20for%20me%2C%20thank%20you%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi all

 

We are having problems pasting into Quick Edit. It just... doesn't work? If I try to paste more than say 10 rows, the screen whites out with the 'Loading' wheel going and no matter how long we wait, it simply hangs.

 

This is across two tenants and several users. Anyone got any ideas? It's really getting in the way of things.

 

I can paste one row at a time, but even that can be patchy, sometimes it only picks up the first one or two fields and then we get the little blue loading wheel in the first cell in the row. 

 

Whenever either of these things happens, the Exit Quick Edit link is unresponsive and we have to exit all the way out to another page, go back in and try again.

 

Screen grab:

 

Loading Hang Snip.PNG

 

Thanks!

 

 
10 Replies
Highlighted

@staregirl I'm experiencing the exact same thing, and it is a major problem for me, too. When I cut and paste rows from Excel into the Quick Edit mode worksheet of a SharePoint list, normally I can do dozens of rows together at a time. As of yesterday, no more than 5 or so rows. I've tried everything to try to coax it back into working - even re-created my list with less fields than desired, and hardly any lookup fields. I sure hope we get some SME attention to this and it gets fixed!

Highlighted
Hi!

Oh, it's so nice to know we're not alone.

*jumps up and down* Hey! anyone know what's happening? I'm now looking at patching data from PowerApps to SharePoint lists because I can't copy/paste and that's more workaround than I'd like...
Highlighted

@staregirl Sigh, me too. Cant paste any data in. Any ideas?

Tried all the usual suspects, different browsers, new list, simple data etc.

 

Has a call to Microsoft been logged by any chance?

 

Andrew

Highlighted

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

Highlighted

@Clodine Ah thats great, I will give that a go tomorrow morning.
Thank you for the info!

@Clodinethat's great, I'll have a go now and hopefully we can stagger on while they look into it. Thanks so much!

Highlighted

I had found that workaround, but not a good option for me.  tried list settings > advanced settings > list experience > classic experience to get closer to a workable option, but doesn't seem to do anything.  has anyone used that? @Clodine 

Highlighted

@D_W-1 No, didn't try that as the basic work-around works well enough for me for now. I just switch over briefly to Classic mode for my "bulk copy-paste" and then go back to modern. Good luck!

Highlighted

@staregirl @Andrew Thornton-Smith @D_W-1 - the fix is on the way; I think my testing helped identify the cause. I'm in a targeted release group for my company, and just tested. I was able to copy-and-paste well over 100 rows from an Excel file into a SharePoint list using Quick Edit Mode in Modern experience. I HAVE NO IDEA THE PUSH/RELEASE SCHEDULE FOR THIS, so the fix may or may not be there for you (and possibly some of my colleagues) for a while. I'd recommend you periodically test, esp. after the next 2-3 SharePoint release updates. Good luck! And bye bye.

Highlighted
This solution of copying from excel to quick edit worked for me, thank you :)