Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum Unique Records in Pivot Table
Does anyone know what the max is? I'm getting this message from a
pivot I'm trying to make.... My file is roughly 50,000 records long with 3 data columns, one of which is a number for months. Probably 80% of the 50,000 records have 12 months of entries - thus the # of unique records is probably in the neighborhood of 10,000. Is this too many? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum Unique Records in Pivot Table
http://support.microsoft.com/?kbid=211517
XL2000: Limits of PivotTables in Microsoft Excel 2000 "There is a limit of 8,000 unique items per row field, column field, or page field. " -- Regards, Tom Ogilvy "Marston" wrote in message om... Does anyone know what the max is? I'm getting this message from a pivot I'm trying to make.... My file is roughly 50,000 records long with 3 data columns, one of which is a number for months. Probably 80% of the 50,000 records have 12 months of entries - thus the # of unique records is probably in the neighborhood of 10,000. Is this too many? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
//pivot - unique records . | Excel Worksheet Functions | |||
Unique records in pivot table - formula? | Excel Discussion (Misc queries) | |||
Unique records in Pivot Table | Excel Discussion (Misc queries) | |||
unique records in pivot table | Excel Discussion (Misc queries) | |||
unique records in Pivot Table | Excel Discussion (Misc queries) |