Pivot Table - Max Unique Items

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top