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

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