| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables using multiple worksheets
Hi,
I have a workbook with 12 worksheets (one for each month) with around 40,000 records in each. Is it possible to create a Pivot Table to enable me to analyse the whole year? Any help will be greatly appreciated. Thanks Alan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables using multiple worksheets
If anyone can help with this, then that would be great, as i have similar
models, where i want to combine data. I heard the max number of consolidated ranges etc was 6. Thanks Matt AlanMB wrote: Hi, I have a workbook with 12 worksheets (one for each month) with around 40,000 records in each. Is it possible to create a Pivot Table to enable me to analyse the whole year? Any help will be greatly appreciated. Thanks Alan -- Matt Lynn Message posted via http://www.officekb.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables using multiple worksheets
You can create a pivot table from the data on separate sheets (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 all your data on one sheet, or in a database, and create the pivot table from that. AlanMB wrote: Hi, I have a workbook with 12 worksheets (one for each month) with around 40,000 records in each. Is it possible to create a Pivot Table to enable me to analyse the whole year? Any help will be greatly appreciated. Thanks Alan -- 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 | |||
| Multiple pivot tables | Excel Worksheet Functions | |||
| build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
| how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
| Creating Tables From Multiple Worksheets | Excel Worksheet Functions | |||
| In Excel combine tables from multiple worksheets in to one sheet? | Excel Worksheet Functions | |||
Linear Mode
