Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Limits (Excel 2000)

    I am getting a message when I attempt to drag a row field onto a Pivot table that "A field in your source data has more unique items than can be used in a Pivot table. It goes on to say that Excel might not be able to make the table or use the field. What are those limits? There are 9058 asset numbers in this particular field...I am attempting to have a by-account by-asset number list. I was successful under Excel 2002 or whatever the next release was. New situation has 2000...would that be it? Thanks.

  2. #2
    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 Limits (Excel 2000)

    That is exactly it.


    8,000 is the maximum unique items in a pivot table in XL2000 (see this article for other limits in XL2000

    32,500 is the max in XL2002 (see this article)


    Steve

Posting Permissions

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