Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello -
I am receiving the following error in an Excel pivot table when I try to drag a page field into the row fields area of my pivot table: Microsoft Excel cannot make this change because there are too many row or column items... I'm using Excel 2002 (part of Offce XP Pro, running on Windows XP Pro), and I've found KnowledgeBase article 291061 which references limits in pivot tables in this version of Excel, but I don't believe that I could be hitting any of these limits. There are only approximately 5,000 rows of raw data in the data source for this table, so I can't see how I could have more than the maximum allowable number of "actual axis intersections" as defined in the article. I'd appreciate clarification as to what these limits really mean, and as to exactly limit I'm hitting. Thanks. - Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
One pivot table cannot overlap another pivot issue. | Excel Discussion (Misc queries) | |||
Pivot table column limits | Excel Discussion (Misc queries) | |||
row limits excel 2007 restricting pivot table calculations | Excel Discussion (Misc queries) | |||
Pivot table Limits? | Excel Discussion (Misc queries) | |||
Pivot table limits | Excel Worksheet Functions |