View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NahDjiri NahDjiri is offline
external usenet poster
 
Posts: 1
Default Excel Pivot Tables

What is the maximum number of unique items a Pivot Table can display? I'm
using MS Excel 2000 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 a pivot table. Microsoft Excel may not be able to
creat the Pivot Table, or may create the Pivot Table without data from this
field."