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
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » 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.
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.
Notifications