Excel 2013 refresh pivot table from new data file in a depository

[Nody224]

Hello,

I need to create a macro which refresh my pivot table with a specific file which may change over time but stay similar in the form, number of columns etc,

I think I have the code to refresh the pivot table but it’s effective only if we modify the data source, adding data or deleting. But I want to completely change the file of the data source.

Thanks for your help,