Maximum Unique Records Pivot Excel2010

[brendanolear]

I have a report with 35000 rows of data, Col a has a unique product ID.

Previously, I could drag this unique ID into a pivot without problem, however I canno longer do so and receive the message "A Field in your source data has more unique items than can be used in a pivot table".

I suspect this is not as a result of row count but unsure where to start.

I previously used 2003 and only recently maoved to 2010, never had this problem before.

Anyone able to help!!

 

[look]

I used Excel 2003 and the max was 8,192 unique identifiers.

Got around problem by breaking up data and combining pivots.

Thanks