Jul 11 2019 03:01 AM
Excel 2013
I have lot of working excel workbooks, that are update on daily basis from several users.
I wish to push to a Sharepoint list a standard content (table) in order to create only one table for making reports and comparisons among all worksheets data.
In the previous Excel version there was an add-on available to do this job (syncronizewssandexcel.xlam), but now I am not able to find it (seems deprecated).
How can I get out from this stumbling block? There is another supported method?
Jul 15 2019 02:44 AM
Unfortunately, over the course of the last few years, the previously strong link between Excel workbooks and SharePoint lists has been neglected. It is now no longer easy to synchronize changes in an Excel workbook to a SharePoint list.
If you are using SharePoint online with an Office 365 plan that includes Flow, you can build a flow to update a SharePoint list item when the Excel file is changed. The mechanics of this has many moving parts, though, and requires, if not programming skills, at least a programmer's understanding of how data is stored and retrieved.