| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Pivot Table Data Source to multiple ranges
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Changing Pivot Table Data Source to multiple ranges
Excel 2007 PivotTable
With multiple consolidation ranges. Add ranges. http://c0444202.cdn.cloudfiles.racks.../12_23_09.xlsm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Data Source on Multiple Pivot Tables at once | Excel Worksheet Functions | |||
| pivot table multiple worksheet source data | Excel Discussion (Misc queries) | |||
| Changing Pivot Table source | Excel Discussion (Misc queries) | |||
| Changing Data Source for Pivot Table | Excel Discussion (Misc queries) | |||
| Changing data source in pivot table- "Back" button is disable | Excel Discussion (Misc queries) | |||
Hybrid Mode
