Can Pivot tabel be linked to multi-tabs?

  • Thread starter Thread starter yhoy
  • Start date Start date
Y

yhoy

Due to capacity constraint, data are cut into multi-tabs. How to create Pivot
out of all of them, if possible?

Thanks!
 
You can create a pivot table from multiple consolidation ranges, but the
results may not be exactly what you want. There's more information here:

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

Perhaps you could store the data in a database instead, and base the
pivot table on that.
 
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

One pivot table for multiple worksheets/tabs 2
pivot table, Average formula 3
Refreshing Pivot Table on a protected spreadsheet tab 1
Automatically Refresh pivot table 6
Pivot Tables 1
How do I add extra data to a pivot table? 3
Refreshing Pivots in multiple tabs 9
how to pivot data from several tabs 3

Back
Top