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...=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



"Jeff Richman" wrote in message ...
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