I have a sharepoint list that I would like to connect and sync with a pivot table included in an excel file. The excel fiel is a 2010 version and is stored in the same sharepoint. Is it possible to do that?

Thanks in advance. Joel

1 Answer 1


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.