Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Another Pivot Table Question (2003)

    Greetings,

    A co-worker has asked a question about an apparent 'limit' to the number of lines he can bring into his file. He is bringing in a text file (CSV) that carries 214 columns, and the number of rows can vary. Lets say >600. A couple of the columns contain text data the max's out the limit of characters allowed in a cell. He is thinking that this causes a problem for him (but we are not sure).

    I am in the process of getting a file from him so that I can attempt to replicate the issue, but I wanted to start the thread to see what the collective may think up front. I know I have use files with >1000 lines, but not with a cell max'ed.

    thanks,
    Brad

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Another Pivot Table Question (2003)

    You can have 32767 characters in a cell in Excel!
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another Pivot Table Question (2003)

    Ok,,, Got a little more info. He was incorrect in his analysis of the issue. He is able to bring in more lines, but he is thinking the Pivot table ws causing his issue.

    How many fields can be introduced into the table when dragging from the selction list?


    Brad

Posting Permissions

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