Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to understand the limtiations of XL2000 Pivot Tables but am
getting very confused. This could stem from the way the terminlogy is used from one source of definitions to another. In the Excel help (Office Assistant) it says the maximum number of Items in a Pivot Table report is 8,000. Yet, when I read the on-line article (http://support.microsoft.com/kb/211517/) it says the number of unique Items per row, column or page field is 8,000. So, is the maximum number of all row, coumn and page fields 8,000 or is it 8,000 each? Then the article says, the maximum number of items in all column fields cannot exceed 32,768. And the maximum number of items in all row fields cannot exceed 2.1 billion. Whath appened to the 8,000 item limit? Could someone please clarify this for me? Any and all help is greatly appreciated. -- LPS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import File With Specifications | Excel Discussion (Misc queries) | |||
More than 3 specifications for conditional formatting in Excel | Excel Discussion (Misc queries) | |||
How can I automatically rearrange cells to my specifications? | Excel Discussion (Misc queries) | |||
How to increase colums specifications? | Setting up and Configuration of Excel | |||
Where can I find a template for application report specifications. | Excel Discussion (Misc queries) |