Forum Discussion
Updating SharePoint List from Excel
John White, jcgonzalezmartin is there a way to update a sharepoint list from Excel? (other than through 3rd party tools like SoftFluent's Sharepoint list synchronizer? SharePoint List Synchronizer)
bronniecplaceThank you for looking for answers on this topic. I've been watching it. Your reply doesn't address how to make these edits in Excel. Meaning, if I have an Excel spreadsheet linked to SharePoint, can I have it set to update particular columns for items already added and synced. For example, if I have an inventory list in excel that is set to export to SharePoint, can I edit prior rows (maybe like a quantity column that has how many of the item I have on hand) and have Excel recognize that the change needs to update an existing row and not create a new row. The goal is to be able to automate the update to existing rows on SharePoint using a master list in Excel.
I happen to know that January 10, 2020 .. Fusion Free-Edition Is launching, and it does that and 100 other tasks on steroids!
Stay tuned 🙂
Stay tuned 🙂