Formulas, Functions, Formatting, Charts, Data Analysis, etc.
As of June 1st, this forum will be closed.
All new posts should be made at our new Excel Forum at TeachExcel.com.
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: Baidu [Spider], Bing [Bot] and 10 guests