Home

Change Data Source of PivotTables

%3CLINGO-SUB%20id%3D%22lingo-sub-837344%22%20slang%3D%22en-US%22%3EChange%20Data%20Source%20of%20PivotTables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-837344%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20use%20the%20same%20multiple%20pivot%20tables%20each%20month%20but%20with%20a%20new%20data%20source%20(have%20multiple%20pivot%20tables%20on%20monthly%20sales%20and%20sales%20tax%20by%20state).%26nbsp%3B%26nbsp%3B%20Is%20there%20an%20easy%20way%20to%20change%20the%20data%20source%20on%20these%20pivot%20tables%20each%20month%3F%26nbsp%3B%20I%20am%20currently%20going%20to%20each%20pivot%20table%2C%20selecting%20change%20data%20source%2C%20and%20then%20going%20to%20the%20worksheet%20and%20selecting%20the%20data%20range.%26nbsp%3B%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-837344%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
murray_bees
Occasional Visitor

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?

Related Conversations