Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Bradford, Yorkshire, England
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Increase No of Rows

    Is it possible to increase the maximum no of rows on an Excel 97 worksheet. I have been given some data which contains more than 65,536 records.
    I was hoping that there might be a "fix" for this.

    Thanks for any help
    Mich

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Increase No of Rows

    Hi Mich,

    I do not believe it is possible to change the limitations on worksheet size. You might consider breaking your data up into more than one worksheet. I believe there is no limit other than system resources on the size of a workbook.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Increase No of Rows

    No, it is not possible to increase the number of rows. Two possible alternatives would be to split the data onto multiple sheets, or to use a database like Access.
    Legare Coleman

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Increase No of Rows

    Per the other posts, you can't increase the number of rows nor the number of columns. Break up your app into different sheets or use another application like Access or non-Microsoft QuattroPro, or better-yet a serious ARRAY-ORIENTED language like APL...it makes Excel look like a toy.

  5. #5
    ScoobyDoo!
    Guest

    Re: Increase No of Rows

    Excel ISN'T a toy? But I have SO much fun with it!

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Increase No of Rows

    It's not really a toy, but when you need to do serious array processing, it falls apart. Even without the need for array processing: how about the constant cry for more than 65000 rows and 250 cols., OR how about the 7 nested IFs problem, etc.

    When you're array processing, Excel is just not good at it. You have to resort to fairly extensive VBA to get even the simplist work done. For example, removing blank rows from a large sheet. In an array-processing language, that's trivial.

    Obviously, Excel is widely used for trivial and somewhat serious processing of data, but when you're REALLY serious, it tends to fall apart. I'm working on a financial model for a client (it's not a database application!) that is roughly 75000 rows with 500+ columns of data. Forget Excel for that.

  7. #7
    ScoobyDoo!
    Guest

    Re: Increase No of Rows

    I agree completely. I don't often run into the 65000 rows problem, simply because if I have something that large, I tend to look for another solution before I even go there, but I do often run into the nested IF's problem. Very frustrating. Oh, well.

    However, you have to give it this; It's relatively easy for even a novice user to begin using and it's good for what 95% of users need it to do.
    And I think that's their target audience. Obviously there will be things that you can't do with any tool that has such a broad user base.

Posting Permissions

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