MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table limitations

Posted by PJH on December 20, 2001 11:45 AM

Mr Excel and the Excel World:
I'm working out of Excel 2000 and have a inventory file that has 15 thousands rows,3 columns. When trying to do a pivot table I get the following message:
"A field in your source data has more unique items than can be used in a pivot table"
Is there any whay to get around this limitation?

Thanks, Phil

Posted by Mark W. on December 20, 2001 11:59 AM

One of your data fields has more than 8,000 unique
items. This field cannot be used in the PAGE, ROW,
or COLUMN area of your PivotTable. You can create
a PivotTable from this data list with this field
in the DATA area alone.

Posted by DT on December 21, 2001 3:22 AM

I'm sure 'Pierre' will have some really useful advice!