multi sheet pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you create a single pivot table that takes it information from multiple
worksheets within one excel document?
 
You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single
range. There's an example here:

http://www.contextures.com/xlPivot08.html

If you can combine the data in your own database, then use that as the
source, you'll have more flexibility in creating the pivot table.
 
You must log in or register to reply here.

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

Export Pivot table 1
Consolidate Pivot Tables/Cache using Excel 2003 1
reference is not valid message for pivot tables based on Access query 4
making an excel table visible for external data on pivot table 1
Pivot Page field filter based on cell value 3
How to base a pivot table on another pivot table? 3
Pivot table report invalid 0
Pivot Table Help! 1

Back
Top