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
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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies