We use Excel on Win2000 SP4 to crunch raw data for analysis. We really use the Excel filters and plots to a great advantage. Now we are bumping into the 65,000 row limit of Excel.
Does anyone know how we can increase the rows to say 500,000 rows? We checked out the XP version but it appears to have the same row limit. Since we look through many datafiles, breaking the files into pieces and recombining the results by hand is not a good solution. Any ideas??
Thanks in advance.
![]() |
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 |
-
65K row limit (Excel 2002 / SP-2)
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » 65K row limit (Excel 2002 / SP-2)
- This topic has 6 replies, 3 voices, and was last updated 21 years, 6 months ago.
AuthorTopicWSDan..
AskWoody LoungerDecember 11, 2003 at 4:03 pm #397811Viewing 5 reply threadsAuthorReplies-
WSsdckapr
AskWoody LoungerDecember 11, 2003 at 4:08 pm #756001You can use access which (I think) is only memory limited
or you can use multiple sheets as extensions of the list, but you must write routines to keep them straight.In VB you could combine them into arrays to work with them, though I do not know the limitations of the VB arrays.
Steve
-
WSsdckapr
AskWoody LoungerDecember 11, 2003 at 4:08 pm #756002You can use access which (I think) is only memory limited
or you can use multiple sheets as extensions of the list, but you must write routines to keep them straight.In VB you could combine them into arrays to work with them, though I do not know the limitations of the VB arrays.
Steve
-
WSWassim
AskWoody LoungerDecember 11, 2003 at 4:11 pm #756003Dan
Sorry You can not!!! All Excel can handle is 65536 which is 2 to the power of ??? you do the math.
Now there was a glitch in the way the columns, 256 again 2 to the power of ???, when you publish to the web, and it will actually go to ZZ columns, that is from A to AB, to ZZ. Currently it only handles IV which is 256. But when you brought the workbook back to Excel all the extra columns were gone, and truncated.
Best way I can think of working around it, is via a Database and ADO, or text file that can be read into once you need to work with the data.
Maybe you can use multiple worksheets, but again these are solutions that you can try and figure out which one will work best.
Hope this helps.
Wassim
-
WSWassim
AskWoody LoungerDecember 11, 2003 at 4:11 pm #756004Dan
Sorry You can not!!! All Excel can handle is 65536 which is 2 to the power of ??? you do the math.
Now there was a glitch in the way the columns, 256 again 2 to the power of ???, when you publish to the web, and it will actually go to ZZ columns, that is from A to AB, to ZZ. Currently it only handles IV which is 256. But when you brought the workbook back to Excel all the extra columns were gone, and truncated.
Best way I can think of working around it, is via a Database and ADO, or text file that can be read into once you need to work with the data.
Maybe you can use multiple worksheets, but again these are solutions that you can try and figure out which one will work best.
Hope this helps.
Wassim
-
WSsdckapr
AskWoody LoungerDecember 11, 2003 at 4:52 pm #756011FYI, I just did a test and I was able to create an array in VB with over 1 million elements and could fill it with 11 complete columns (720,896 items) of info (in one column) in a little over 3 seconds: so manipulation of multiple sheets in VB is feasible to convert to a “large sheet” in code.
I was also able to make an over 14 million element 2-D array (1,000,000 rows x 14 columns) without any problems (I did get a problem with Memory when I had 1,000,000 x 15 so there is a limit in memory.)
Steve
-
WSsdckapr
AskWoody LoungerDecember 11, 2003 at 4:52 pm #756012FYI, I just did a test and I was able to create an array in VB with over 1 million elements and could fill it with 11 complete columns (720,896 items) of info (in one column) in a little over 3 seconds: so manipulation of multiple sheets in VB is feasible to convert to a “large sheet” in code.
I was also able to make an over 14 million element 2-D array (1,000,000 rows x 14 columns) without any problems (I did get a problem with Memory when I had 1,000,000 x 15 so there is a limit in memory.)
Steve
Viewing 5 reply threads -

Plus Membership
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.
Get Plus!
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.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Is AI Becoming Too Easy to Trust? Where Should We Draw the Line? (Awaiting moderation)
by
Samuel Miz
57 minutes ago -
Is Microsoft Copilot becoming a security risk for sensitive enterprise data? (Awaiting moderation)
by
Samuel Miz
1 hour, 3 minutes ago -
How to get Microsoft Defender to honor Group Policy Setting
by
Ralph
3 hours, 26 minutes ago -
Apple : Paragon’s iOS Mercenary Spyware Finds Journalists Target
by
Alex5723
4 hours, 5 minutes ago -
Music : The Rose Room – It’s Been A Long, Long Time album
by
Alex5723
5 hours, 11 minutes ago -
Disengage Bitlocker
by
CWBillow
6 hours, 35 minutes ago -
Mac Mini M2 Service Program for No Power Issue
by
Alex5723
7 hours, 11 minutes ago -
New Win 11 Pro Geekom Setup questions
by
Deo
8 hours, 55 minutes ago -
Windows 11 Insider Preview build 26200.5651 released to DEV
by
joep517
14 hours, 26 minutes ago -
Windows 11 Insider Preview build 26120.4441 (24H2) released to BETA
by
joep517
14 hours, 28 minutes ago -
iOS 26,, MacOS 26 : Create your own AI chatbot
by
Alex5723
18 hours, 23 minutes ago -
New PC transfer program recommendations?
by
DaveBoston
44 minutes ago -
Windows 11 Insider Preview Build 22631.5545 (23H2) released to Release Preview
by
joep517
22 hours, 27 minutes ago -
Windows 10 Build 19045.6029 (22H2) to Release Preview Channel
by
joep517
22 hours, 28 minutes ago -
Best tools for upgrading a Windows 10 to an 11
by
Susan Bradley
10 hours, 48 minutes ago -
The end of Windows 10 is approaching, consider Linux and LibreOffice
by
Alex5723
8 hours, 10 minutes ago -
Extended Windows Built-in Disk Cleanup Utility
by
bbearren
22 minutes ago -
Win 11 24H2 June 2025 Update breaks WIFI
by
dportenlanger
1 day, 17 hours ago -
Update from WinPro 10 v. 1511 on T460p?
by
CatoRenasci
15 hours, 21 minutes ago -
System Restore and Updates Paused
by
veteran
1 day, 19 hours ago -
Windows 10/11 clock app
by
Kathy Stevens
1 day, 7 hours ago -
Turn off right-click draw
by
Charles Billow
1 day, 23 hours ago -
Introducing ChromeOS M137 to The Stable Channel
by
Alex5723
2 days, 2 hours ago -
Brian Wilson (The Beach Boys) R.I.P
by
Alex5723
20 hours, 36 minutes ago -
Master patch listing for June 10, 2025
by
Susan Bradley
2 days, 4 hours ago -
Suggestions for New All in One Printer and a Photo Printer Windows 10
by
Win7and10
1 day, 7 hours ago -
Purchasing New Printer. Uninstall old Printer Software First?
by
Win7and10
2 days, 10 hours ago -
KB5060842 Issue (Minor)
by
AC641
22 hours, 26 minutes ago -
EchoLeak : Zero Click M365 Copilot leak sensitive information
by
Alex5723
2 days, 17 hours ago -
24H2 may not be offered June updates
by
Susan Bradley
1 day, 10 hours ago
Recent blog posts
Key Links
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.