| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Pivot tabel be linked to multi-tabs?
Due to capacity constraint, data are cut into multi-tabs. How to create Pivot
out of all of them, if possible? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can Pivot tabel be linked to multi-tabs?
You can create a pivot table from multiple consolidation ranges, but the
results may not be exactly what you want. There's more information he http://www.contextures.com/xlPivot08.html Perhaps you could store the data in a database instead, and base the pivot table on that. yhoy wrote: Due to capacity constraint, data are cut into multi-tabs. How to create Pivot out of all of them, if possible? Thanks! -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average of sumed data in pivot tabel | Excel Worksheet Functions | |||
| Cum fac subtotaluri intr-ul Pivot Tabel? | Excel Discussion (Misc queries) | |||
| Updating tabs linked to master tab | Excel Discussion (Misc queries) | |||
| repeat rows for add'l pages for tabs on a multi-tab worksheet | Excel Worksheet Functions | |||
| Multi-Page Word Doc Linked to Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
