• Increase No of Rows

    Author
    Topic
    #356292

    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

    Viewing 2 reply threads
    Author
    Replies
    • #527041

      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.

    • #527048

      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.

      • #527542

        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.

    • #527600

      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.

    Viewing 2 reply threads
    Reply To: Increase No of Rows

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: