Changing Data source

[Paul5099]

Hello all,
I'm new to the site and this is my first post, hopefully someone can assist.
I have a workbook that has about 50 pivot tables that have their source in a table in the same workbook. I would like to change the data source to an external workbook that is located on my teams SharePoint site. Instead of manually changing the data source for each pivot table, I was hoping to change the source for all pivot tables in one step.
Any help would be appreciated.
thanks,
Paul

 

[James006]

Hello,

Have a look at following :

https://contexturesblog.com/archives/2012/04/19/change-data-source-for-all-pivot-tables/

HTH

 

[Paul5099]

Thanks!

 

[James006]

You are welcome