Nov 18 2020 07:51 PM
Hi All,
I have a SharePoint List setup that I want to update from an Excel list.
We have an Actions Register in Excel that we update frequently, I would like to have my SharePoint list updating based upon edits made to the Excel table.
I.e. I open the SharePoint list each day and press refresh and it will populate based upon any changes or additions made to the Excel list.
I know how to copy and paste between the 2, how to export a table to a new SharePoint list, how to export a list from SharePoint to Excel so please don't suggest any of these.
I'm sure there is a way to do what I want somehow as I have seen it done in the past from bigger companies I worked for where there is two-way connections between SharePoint and Excel.
If anyone knows how to do this please help!
Thanks
Nov 18 2020 10:02 PM