Formulas, Functions, Formatting, Charts, Data Analysis, etc.
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.
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?
- 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 4 guests