Issue with Pivot Table Limits

  • Thread starter Thread starter Jeff Richman
  • Start date Start date
J

Jeff Richman

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
 
Hi Jeff,

You may try to search for "specification" in xl's help (xl2002).
You will get the information as following.
PivotTable report specifications
Feature Maximum limit
PivotTable reports on a sheet Limited by available
memory
Items in a PivotTable report 8,000
Row or column fields in a PivotTable report Limited by available
memory
Page fields in a PivotTable report 256 (may be limited by
available memory)
Data fields in a PivotTable report 256
Calculated item formulas in a PivotTable report Limited by available
memory

You may check if you have any related issue in your project.
I look forward to hearing from you.

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
 
Jeff,
I have faced this problem earlier. Pl refer to the excel limitation of
pivit table in the KB art no 820742. It says as below.

Maximum Number of Items for Each Pivot Field :

There is a limit of 32,500 unique items for each row field, column
field, or page field. If you try to drop a field that exceeds this
limit into your PivotTable report, the field is not added to the
PivotTable report, and you may receive the following warning message:

A field in your source data has more unique items than can be used in
a PivotTable report. Microsoft Excel may not be able to create the
PivotTable report or may create the PivotTable report without the data
from this field.


or follow the link below for more details.

http://support.microsoft.com/default.aspx?scid=kb;en-us;820742&Product=ofw#appliesto

I think there is not way around and I have change the layout of my
pivot table.
Please let me know if you get any solution.

Regards,
Ketan
 
Back
Top