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

Pivot Table: deleted source data 1
Change source data of a pivot chart 1
Change source data in a pivot chart 4
Pivot Table-Change Data Source? Excel 2007 1
Pivot Table to reference multiple sheets 1
Category Axis Date Labels 1
Pivot Table Data Source 1
charts and pivot tables 2

Top