Pivot Table - Max Unique Items

[Guest]

I am trying to create a pivot table that has some 10k records/rows. The
column being used in the pivot table has mostly unique items... I am getting
the following error msg

"A field in your source data has more unique items than can be used in a
pivot table. Microsoft excel may not be able to create the pivot table or may
create the pivot table without the data from this field"

This started to occur once the record/row length (or I should say the unigue
items) exceeded about 8005. Is there a way to overcome this / or increase the
number of unique items allowed?

Any help would be greatly appreciated.

Sandy

 

[Debra Dalgleish]

Perhaps you could move some of the fields into the page area.

The following MSKB articles outline PivotTable limitations for different
versions of Excel:

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

Limits of PivotTable Reports in Microsoft Excel 2003
http://support.microsoft.com/default.aspx?id=820742

 

[Guest]

Thank you Debra ! ! Worked Great

Perhaps you could move some of the fields into the page area.

The following MSKB articles outline PivotTable limitations for different
versions of Excel:

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

Limits of PivotTable Reports in Microsoft Excel 2003
http://support.microsoft.com/default.aspx?id=820742