Changing Pivot Table Data Source to multiple ranges

's Computer Specifications

In Excel 2007, I just ran out of room on a tab that feeds into several pivot
tables that feed into other daily and weekly reports. I have found the way
to create a pivot table with multiple consolidation ranges, but have not seen
any way to edit the data source of an existing pivot table to include another
range. Is this possible to do, or do I have to create all new tables?

's Computer Specifications

Excel 2007 PivotTable
With multiple consolidation ranges.
Add ranges.
http://c0444202.cdn.cloudfiles.racks.../12_23_09.xlsm

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing Pivot Table Source Data	Barb Reinhardt	Microsoft Excel Programming	1	15th Apr 2009 06:58 PM
Changing Data Source on Multiple Pivot Tables at once	marjhan	Microsoft Excel Worksheet Functions	1	23rd Oct 2008 09:03 AM
How to refresh a pivot table that uses changing source data	Mike C	Microsoft Excel Programming	1	13th Feb 2008 01:54 AM
Problem Changing Data Source In Pivot Table	SHMUNCY	Microsoft Excel Discussion	0	12th Jun 2006 09:09 PM
Changing Data Source for Pivot Table	jjj	Microsoft Excel Misc	1	13th Apr 2006 09:36 AM