Excel Pivot table- Multiple Sheets

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

Guest

Is it possible to combine multiple sheets in generating a single pivot table?
 
Hi
yes it is. Choose the appropiate option in the pivot table wizard 8in
the first tab). Should be the third option in this sheet
 
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 possible, move your data to a single worksheet, or store it in a database, such as MS Access, and 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

Pivot table data source 1
Pivot from all sheets 1
Pivot Table - Changes 5
Pivot Table - include multiple worksheets with different ranges. 1
about pivot table 1
Pasted Pivot Table looks at old sheet 1
Adding to an existing Pivot Table 7
One pivot table for multiple worksheets/tabs 2

Back
Top