Excel Pivot Tables
Its around 8000 unique records. You will need to upgrade to 2007.
--
Dan
Office 2007
"NahDjiri" wrote:
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."
|