Quick Edit only partially working

%3CLINGO-SUB%20id%3D%22lingo-sub-1563654%22%20slang%3D%22en-US%22%3EQuick%20Edit%20only%20partially%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563654%22%20slang%3D%22en-US%22%3E%3CP%3EI%20used%20Export%20to%20Excel%20for%20a%20list%20so%20I%20could%20make%20some%20bulk%20edits.%20I%20deleted%20the%20list%20so%20I%20could%20re-import%20it%20without%20creating%20duplicates.%20After%20making%20the%20necessary%20edits%2C%20I%20am%20now%20trying%20to%20use%20Quick%20Edit%20to%20paste%20the%20list%20back%20into%20place.%20It%20is%20only%20pasting%20in%20a%20few%20rows%20at%20a%20time%20and%20sometimes%20only%20part%20of%20a%20row%20will%20fill%20in.%20The%20other%20rows%20don't%20fill%20in%20at%20all.%20I%20then%20have%20to%20Exit%20Quick%20Edit%2C%20reload%20the%20page%2C%20and%20then%20I%20can%20try%20to%20paste%20in%20the%20remaining%20rows.%20But%20again%2C%20it%20will%20only%20take%20a%20few%20rows%20and%20I%20have%20to%20repeat%20the%20process.%20It's%20not%20a%20huge%20list%20(26%20rows%2C18%20columns).%20I%20can%20do%20it%20a%20few%20rows%20at%20a%20time%20but%20I'm%20concerned%20that%20sometimes%20the%20entire%20row%20doesn't%20fill%20in%20and%20I%20might%20miss%20some%20data%20and%20not%20realize%20it.%20Any%20idea%20why%20this%20is%20happening%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1563654%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564021%22%20slang%3D%22en-US%22%3ERe%3A%20Quick%20Edit%20only%20partially%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564021%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20may%20have%20something%20to%20do%20with%20list%20items%20with%20%22Allow%20multiple%20selections%22%20enabled.%20When%20you%20export%20a%20cell%20with%20multiple%20selections%20it%20used%20a%20%22value1%3B%23value2%22%20format.%20Does%20that%20cause%20some%20sort%20of%20problem%20when%20trying%20to%20use%20quick%20edit%20to%20update%20cells%20in%20those%20columns%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

I used Export to Excel for a list so I could make some bulk edits. I deleted the list so I could re-import it without creating duplicates. After making the necessary edits, I am now trying to use Quick Edit to paste the list back into place. It is only pasting in a few rows at a time and sometimes only part of a row will fill in. The other rows don't fill in at all. I then have to Exit Quick Edit, reload the page, and then I can try to paste in the remaining rows. But again, it will only take a few rows and I have to repeat the process. It's not a huge list (26 rows,18 columns). I can do it a few rows at a time but I'm concerned that sometimes the entire row doesn't fill in and I might miss some data and not realize it. Any idea why this is happening?  

 

 

 

1 Reply
Highlighted

This may have something to do with list items with "Allow multiple selections" enabled. When you export a cell with multiple selections it used a "value1;#value2" format. Does that cause some sort of problem when trying to use quick edit to update cells in those columns?