Pivot Table Error Message

[Kirk P.]

I received the following message when dragging my "Products" item onto my Pivot Table.

"A field in your source data has more unique items than can be used in a Pivot Table."

I have 14,802 unique Product items. Does anyone know what the limitation is AND how to get around it?

 

[Debra Dalgleish]

The following MSKB article outlines the PivotTable limits in Excel 2002,
and has links to articles on other versions:

XL2000: Limits of PivotTables in Microsoft Excel 2000
http://support.microsoft.com/default.aspx?id=211517

XL2002: Limits of PivotTables in Microsoft Excel 2002
http://support.microsoft.com/default.aspx?id=291061