Changing Pivot Table Data Source to multiple ranges

T

Tom Garner

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Consolidation Table from Different Excel Tabs with Different Format 1
Pivot Table-Change Data Source? Excel 2007 1
Pivot Table Data Aggregation 0
Excel 2007 pivot table using analysis services cube as data source 0
Pivot Table Counting Text Data 0
Change source data of a pivot chart 1
Changing pivot table ADO recordset 0

Top