SharePoint Asked by Thijs on December 19, 2021
For a specific use case, I need to synchronize/update all items in a SharePoint 365 List with fresh data from an excel sheet.
If the sheet contains new items, they should be added to the list. If items are removed, they should be removed from the list.
The Excel sheet has a column with a unique identifier that can serve as primary key.
I’m looking for a way to do this without any additional coding.
My questions:
Things I’ve tried:
I had the same issue but out of frustration I tried Internet Explorer over my standard Chrome. Pasted fine :)
Had similar issue with the Connect to Explorer functionality - works in IE but doesn't work in Chrome...
hope it helps !!
Answered by Chris on December 19, 2021
try opening it in MS Access. you can paste multiple rows at a time (100+) and sync it back to sharepoint
Answered by betterbuddha on December 19, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP