synchronization – How to sync an excel pivot-table with a sharepoint list?


you have two approaches

1.- install the powerpivot add-in for sharepoint, this will allow you to export lists as data feeds that can be loaded and refreshed from excel

2.- if you have excel 2016 you can import data from excel from the data tab/get and transform , new query from sharepoint, then on save and load you can load the result to a pivot table or a powerpivot data model