5000 item limit- worked before and after changes not working anymore

%3CLINGO-SUB%20id%3D%22lingo-sub-1321322%22%20slang%3D%22en-US%22%3E5000%20item%20limit-%20worked%20before%20and%20after%20changes%20not%20working%20anymore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1321322%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recently%20exported%20my%20sharepoint%20list%20to%20excel%20so%20I%20could%20update%20the%20details%20of%20one%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20chose%20to%20do%20it%20this%20way%20as%20it's%20quicker%20in%20excel%20to%20populate%20one%20column%20that%20had%20many%20empty%20cells%20with%20a%20default%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I%20re-imported%20the%20spreadsheet%20back%20into%20the%20same%20list%20and%20now%20I%20get%20these%20errors%20(note%20the%20number%20of%20rows%20did%20not%20change)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20and%20view%20the%20list%20I%20see%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EWhen%20I%20changed%20back%20to%20the%20classic%20view%20I%20see%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELastly%2C%20under%20settings%20I%20see%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20and%20please%20help%20me%20get%20back%20to%20functionality.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDaniel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1321322%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-1321535%22%20slang%3D%22en-US%22%3ERe%3A%205000%20item%20limit-%20worked%20before%20and%20after%20changes%20not%20working%20anymore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1321535%22%20slang%3D%22en-US%22%3EHi%2C%20I%20think%20I%20know%20what%20I%20did%20wrong.%20I%20assumed%20that%20if%20I%20did%20the%20%22append%20to%22%20query%20in%20Access%20whereby%20I%20push%20the%20rows%20from%20the%20updated%20version%20of%20the%20excel%20table%20to%20the%20sharepoint%20list%20that%20the%20item%20codes%20which%20are%20unique%20fields%20would%20cause%20those%20existing%20records%20in%20the%20SP%20list%20to%20update.%20Instead%20it%20created%20those%20lines%20as%20new%20lines%20increasing%20the%20total%20number%20of%20records.%20I%20ran%20this%20query%20numerous%20times%20as%20i%20kept%20getting%20errors%20on%20the%20query%20but%20it%20appears%20that%20those%20queries%20were%20at%20least%20partially%20successful.%20The%20original%20number%20of%20items%20was%202540%20and%20now%20it's%2010x%20that%20amount.%20Is%20there%20a%20way%20to%20retrace%20my%20steps%20and%20restore%20my%20list%20to%20an%20earlier%20version%20before%20all%20these%20new%20items%20were%20added%3F%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I recently exported my sharepoint list to excel so I could update the details of one column. 

 

I chose to do it this way as it's quicker in excel to populate one column that had many empty cells with a default value.

 

Now I re-imported the spreadsheet back into the same list and now I get these errors (note the number of rows did not change):

 

When I try and view the list I see this:

 

 

When I changed back to the classic view I see this:

 

Lastly, under settings I see this:

 

 

Thank you and please help me get back to functionality.

 

Regards, 

 

Daniel

1 Reply
Hi, I think I know what I did wrong. I assumed that if I did the "append to" query in Access whereby I push the rows from the updated version of the excel table to the sharepoint list that the item codes which are unique fields would cause those existing records in the SP list to update. Instead it created those lines as new lines increasing the total number of records. I ran this query numerous times as i kept getting errors on the query but it appears that those queries were at least partially successful. The original number of items was 2540 and now it's 10x that amount. Is there a way to retrace my steps and restore my list to an earlier version before all these new items were added?