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."

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."

Is there a limit for 07? I am at 50000 records and climbing.

"Dan" wrote:

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."

CHW - if its records, I passed 1 million a few months ago. If its unique
values in drop downs, I remember reading 250,000 somewhere.

--
Dan
Office 2007


"CHW" wrote:

Is there a limit for 07? I am at 50000 records and climbing.

"Dan" wrote:

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."

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