Hi.  We currently update a SP list using an Excel spreadsheet that compares new stuff to what’s already in the list.  Anything new in the spreadsheet that isn’t in the list gets copied/pasted to the bottom of the list.  That still works.  But we also identify anything that needs to be removed (i.e., it’s in the SP list but not in the updated Excel sheet, and the only way to transfer that info to the SharePoint list is to copy from the Excel sheet and paste into the SP list (grid view).  Then the list can be filtered on flagged items to remove them.  That part is no longer working.  

Prior to June 2024, that process did work, albeit very slowly and poorly; could paste in only ~100 records at a time.  Then in June, something changed with SP, and the look of list changed, but so did the performance – to the better!  Still not 100% great, but way better than before.  But, sometime during the first week of September, Microsoft rolled SharePoint back, and now I don’t seem to be able to paste in anything.  At all. 

This is a major impact and setback to our processes.  Does anyone have any information on what MS did and why?  I’ve even got a ticket in with a Microsoft Support Escalation Engineer, and she said, “I have not found anything indicating why they made the change but I know they made a lot of changes to the Lists recently.”.  I appreciate any information folks may have – including a better way to update a SP list.  Thank you!

​Hi.  We currently update a SP list using an Excel spreadsheet that compares new stuff to what’s already in the list.  Anything new in the spreadsheet that isn’t in the list gets copied/pasted to the bottom of the list.  That still works.  But we also identify anything that needs to be removed (i.e., it’s in the SP list but not in the updated Excel sheet, and the only way to transfer that info to the SharePoint list is to copy from the Excel sheet and paste into the SP list (grid view).  Then the list can be filtered on flagged items to remove them.  That part is no longer working.   Prior to June 2024, that process did work, albeit very slowly and poorly; could paste in only ~100 records at a time.  Then in June, something changed with SP, and the look of list changed, but so did the performance – to the better!  Still not 100% great, but way better than before.  But, sometime during the first week of September, Microsoft rolled SharePoint back, and now I don’t seem to be able to paste in anything.  At all.  This is a major impact and setback to our processes.  Does anyone have any information on what MS did and why?  I’ve even got a ticket in with a Microsoft Support Escalation Engineer, and she said, “I have not found anything indicating why they made the change but I know they made a lot of changes to the Lists recently.”.  I appreciate any information folks may have – including a better way to update a SP list.  Thank you!  Read More

​