multiple pivot data sources into one

B

boris

I need to consolidate multiple pivot data sources into
one. My limitation is page size, so all columns are
exactly the same title and format on each page. But I
can't get them all together. What do I do? It seems the
multiple range option only lets me call something Row
Column or Value. I am selecting no pages. Is this wrong?
 

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

Embed the same Excel multiple times 0
Pivot Table Counting Text Data 0
Column limit for Pivot Table data source 1
Pivot tables - Editing the data source shared by multiple pivot ta 1
Pivot table data source 1
Calculate a pivot table that has consolidated multiple worksheets 0
Pivot table - multiple data sources 2
Change Data Source for Multiple Pivot Tables 1

Top