LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Issue with Pivot Table Limits

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
One pivot table cannot overlap another pivot issue. Avi Excel Discussion (Misc queries) 1 October 5th 09 02:29 PM
Pivot table column limits TJ Dowling Excel Discussion (Misc queries) 2 July 8th 09 08:02 PM
row limits excel 2007 restricting pivot table calculations Jazz Excel Discussion (Misc queries) 0 August 8th 07 05:32 AM
Pivot table Limits? Robbie Excel Discussion (Misc queries) 1 April 8th 05 06:06 PM
Pivot table limits neilamor Excel Worksheet Functions 1 February 17th 05 04:44 PM


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"