On Nov 27 2007, 4:26 pm, NahDjiri
wrote:
What is the maximum number of unique items aPivotTable can display? I'm
using MSExcel2000 and in trying to summarize data that have 14,140 unique
values, I get the error message "a field in your source data has more unique
items than can be used in apivottable. MicrosoftExcelmay not be able to
creat thePivotTable, or may create thePivotTable without data from this
field."


I would use a new tool that called prism
there maximum number of items you can put on the pivot in much more
the excel
and it supports all excel versions

dono if it will help you but you can try it at
www.sisense.com