Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table (2000)

    I am trying to replicate a pivot table that I received. I can see what their pivot table is doing but I can't seem to get my pivot table to work. Whevever I put this one field (Client Number) in the row area, double click on it, I get the following error: "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 create the pivot table or may create the pivot table without the data from this field. When I double click this same field in the original pivot table. it opens up a Pivot Table Filed box where I can designate "none" for sub Totals. I am using the same data to create my pivot table but I get an error message when I try to get to the Pivot Table Field box. Does anyone know why I would be getting this error. When I double click all the other fields, I do get the Pivot table field box. Can't understand what is going on.......

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Table (2000)

    The row field(s) of a pivot table can display a maximum of 8,000 unique items. Apparently you have more than 8,000 distinct Client Numbers, so this field cannot be used as a row field.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table (2000)

    That seems logical but somehow the original pivot table which has more than 8000 distinct client numbers, works. I can double click on the client number field in the row area and it opens the Pivot table field box. We are having a meeting tomorrow to see what they are doing. Thanks for your help. I will let you know how they get this to work with more than 8000 unique items in this field.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Pivot Table (2000)

    Was the original pivot table made in a newer version of XL than XL2000?

    The limit up to XL2000 was 8,000 unique items (Limits of PivotTables in Excel -2000), in XL2002 the limit was expanded to 32,500 (Description of the limits of PivotTable reports in Excel-2002/2003

    Steve

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table (2000)

    That may be the answer - the pivot table was created in Excel 2002. Is Excel 2002 backward compatable? I can open Excel 2002 in Excel 2000?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Table (2000)

    The file format for Excel hasn't changed since Excel 97, so you can open a workbook created in Excel 2002 in Excel 2000. If the workbook created in Excel 2002 has a pivot table with over 8,000 unique items in a row field, it will still work, but you won't be able to add new row fields with over 8,000 unique items, since Excel 2000 doesn't support that.

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table (2000)

    Maybe I am thinking of Access and not being able to open an Access 2002 database in Acesss 2000.
    So the reason I couldn't recreate the pivot table in Excel 2000 was the column limitation of 8000 but the pivot table that was created in Excel 2002 was able to be brought up in Excel 2000 with over 8000 in the column since it was created already. Thanks for the explanation.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •