Update data source for multiple pivot tables as a group?

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
Forum Rules Please read the forum rules before posting!

Put CODE tags around your macro/vba code in a post. Easy way to do this: select the macro/vba in your post and click the CODE button above where you input the text.

Update data source for multiple pivot tables as a group?

Postby bzager2 » Fri Jul 26, 2013 1:56 pm

I have an Excel 2010 file where I've created multiple pivot tables on a single worksheet using the same data source. Then I have another worksheet with multiple pivot tables created from a second data source. (I use equations to pull the answers from the many pivot tables into a report.) I overwrite the data sources with the new data files and refresh all to update the pivot tables and the report. I've gotten to the point where my data file has more rows than my original pivot table data source. I can update each pivot table separately to change the data source and change the number of columns but I have a lot of pivot tables. Is there a way to change the data source for a group of pivot tables at one time? (I want to update the source of all the pivot tables on one worksheet at a time as the other tabs refer to other data sources.) Can anyone help me?
  • 0

bzager2
 
Posts: 1
Joined: Jul 26, 2013
Reputation: 0
Excel Version: Excel 2010

Return to General Excel Questions

Who is online

Users browsing this forum: Bing [Bot] and 6 guests