Forum Discussion

murray_bees's avatar
murray_bees
Copper Contributor
Sep 04, 2019

Change Data Source of PivotTables

Hi all,

 

I need to use the same multiple pivot tables each month but with a new data source (have multiple pivot tables on monthly sales and sales tax by state).   Is there an easy way to change the data source on these pivot tables each month?  I am currently going to each pivot table, selecting change data source, and then going to the worksheet and selecting the data range.  Any ideas?

No RepliesBe the first to reply