Re: exceeding 65536 rows?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"BobS" <no-spam@xxxxxxxxxxx> wrote in message
news:ObazQ4vzIHA.2208@xxxxxxxxxxxxxxxxxxxxxxx

"Jeff@xxxxxxxxxxx" <JeffMalka@xxxxxxxxxxxxx> wrote in message
news:enOqwmpzIHA.3496@xxxxxxxxxxxxxxxxxxxxxxx
Using Excel 2002 and have discovered that there is a limit of 65536 rows.
Is there a way to exceed this number of rows in a single spreadsheet?


Jeff,

No you can't not without upgrading to Excel 2007. But if you can live
with multiple sheets having up to 65,536 rows each then there is a
solution.

I just did this for a project that has over 400,000 records in a 24hr log
file. This routine imports the records and automatically adds sheets as
needed. Since you cannot use more than 65,536 rows per sheet your only
choice is to upgrade to Excel 2007 or to use multiple sheets.

The original subroutine was written by Chip Pearson and can be found
here:

http://www.cpearson.com/excel/ImportBigFiles.htm

ImportBigFiles is the routine you want along with the accompanying
Function - IsFileOpen to verify that the file you're opening is not
in-use.

His routines work nicely and the documentation he includes is like reading
a "How To" manual - excellent. These routines are now embedded in the
project workbook which will run without any changes in both Excel 2003 &
2007. So if you do upgrade later, it will still work.

Bob S.

Thanks Bob. That is very helpful and I will explore it further.

I downloaded OpenOffice to see what it had but it too is limited to 65,536
rows, so it did not help.

Jeff


.

Relevant Pages

  • Re: exceeding 65536 rows?
    ... No you can't not without upgrading to Excel 2007. ... multiple sheets having up to 65,536 rows each then there is a solution. ... choice is to upgrade to Excel 2007 or to use multiple sheets. ... ImportBigFiles is the routine you want along with the accompanying ...
    (microsoft.public.excel)
  • Re: exceeding 65536 rows?
    ... Roland Schorr & Tower ... No you can't not without upgrading to Excel 2007. ... choice is to upgrade to Excel 2007 or to use multiple sheets. ... ImportBigFiles is the routine you want along with the accompanying ...
    (microsoft.public.excel)
  • Re: exceeding 65536 rows?
    ... I have an old version of Quattro Pro ... choice is to upgrade to Excel 2007 or to use multiple sheets. ... So if you do upgrade later, ...
    (microsoft.public.excel)
  • Re: exceeding 65536 rows?
    ... row capability for many years - it is significantly cheaper than Excel ... choice is to upgrade to Excel 2007 or to use multiple sheets. ... So if you do upgrade later, ...
    (microsoft.public.excel)
  • Re: A programming wiki?
    ... user 2, change routine xx, so it becomes version 1.1. ... By inspecting the changes others made, user1 can upgrade his routines if he wants to. ... Or the other users could just compile the new version, and see for themself if they want the added stuff or not. ... You may upgrade rights by way of contributions. ...
    (alt.lang.asm)