Forum Discussion

Copper Contributor

Sep 25, 2020

Sharepoint List From Excel with bi-directional updating?

I'm a newbie to Sharepoint and Teams but have been playing around with Sharepoint Lists and I understand that you can create a list from an existing spreadsheet. However I need a little more than tha...

SharePoint Online

Steven Andrews

Iron Contributor

Sep 25, 2020

OJohnson

The two way sync between SharePoint and any generated lists was removed in SharePoint 2007, a very long time ago. Microsoft did come up with an Excel add-in for Excel 2007 & SharePoint 2007 that's still floating about that may be of some use for you. If I can find it, I'll edit the post with the link otherwise the solution was documented on Code Project https://www.codeproject.com/Articles/134054/Restoring-Two-Way-Synchronization-on-SharePoint-Li.

A better way may be to have the manager simply maintain the SharePoint list rather than a spreadsheet. Any spreadsheet generated from SharePoint does retain a data connection to the parent list. The refresh frequency can be configured in Excel to pull down any edits to the source list on a frequent basis.