Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PIVOT TABLES IN VBA
Question -
Is it possible to create a pivot table on a range or array larger than 65,000 rows ? Can it be done in VB off the worksheet? Once it has been created, is it possible to do a split page as is possible in Pivot tables? I'm working with a very large dataset and this might be a good approach. The reason I'm not looking to do it on a worksheet (in addition to the fact that its too big) is that many of the split pages will have no values and I only need those that do. Effectively the P/T would have 2 page drivers, about 5 row, 1 column, and the sum. Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PIVOT TABLES IN VBA
Must be done in a worksheet in Excel.
I suppose you can do it, because there is an option in the setup wizar to use "multiple consolidation ranges". You don't get as much layou flexibility though. Pages are possible. The final table cannot excee certain limitations, as with any PT. I would link to an MS Access table in this scenario -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PIVOT TABLES IN VBA
That would be nice, but we don't have Access
BrianB wrote in message ... Must be done in a worksheet in Excel. I suppose you can do it, because there is an option in the setup wizard to use "multiple consolidation ranges". You don't get as much layout flexibility though. Pages are possible. The final table cannot exceed certain limitations, as with any PT. I would link to an MS Access table in this scenario. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot tables-controlling user interaction with pivot tables | Excel Programming |