Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: I get This error message

  1. #1
    Guest

    Default

    i whant to create a pivot table from a sheet that has 5 colums and 39442 rows and get this error" a field in your source data has more 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". PLEASE help me
    thank you

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The maximum number of "items" that a PivotTable can have is 8,000. To understand what an item is look at the Excel Help topic for "Parts of a PivotTable". Item examples are shown in yellow. So let's say that one of your PivotTable fields consists of 8,001 unique date values and you wanted to display them all. That would exceed this limit.

  3. #3
    Guest

    Default

    Thank you Mark for your quick reply
    I did work with worksheets that have a lot more than 8000 items with no problem. On Friday I made a Pivot Table with 25000 and had no problem. I selected the first 25000 rows of this file as the range and had no problem. I'm using Excel 97 SR1

  4. #4
    Guest

    Default

    You are right the first 25000 rows had less than 8000 unique items
    Thank you very much for your help it is greatly appreciated

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I s there a wau to measure the number of unique items in a database that will result in a limit with a pivot table? i am running into this problem and my database has 10000 cells but I don't know the number of unique items.

  6. #6
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi deuxo

    Have you had a play with Advanced Filter?



  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Friend,

    I have a file nos.5 and 22 which can help you to extract unique values.

    You can see the code fro file nos.22.

    I hope this can help you to extract unique value.


    http://www.pexcel.com/download.htm

    And thank you board.. i came to know that pivotal table takes 8000 unique values only.

    And yes before you use this code..please take the backup of your original file.
    ni****h desai
    http://www.pexcel.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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