|  | exceeding 65536 rows? | | |
| | | Jeff@unknown.com |  |
|  Posted: Sun Jun 15, 2008 1:41 am Post subject: exceeding 65536 rows? |  |
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? |
| |
| | | T. Valko | |
| | Posted: Sun Jun 15, 2008 1:54 am Post subject: Re: exceeding 65536 rows? | |
In a word, no.
Excel 2007 has been expanded with more than 1 million rows and more than 16K
columns.
--
Biff
Microsoft Excel MVP
"Jeff@unknown.com" <JeffMalka@orthohelp.com> wrote in message
news:enOqwmpzIHA.3496@TK2MSFTNGP03.phx.gbl...
| Quote: | 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?
|
|
| |
| | | Ben M. Schorr - MVP (OneN | |
| | Posted: Sun Jun 15, 2008 2:05 am Post subject: Re: exceeding 65536 rows? | |
Yes. Upgrade to Excel 2007. :)
--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
LINK
LINK
"Jeff@unknown.com" <JeffMalka@orthohelp.com> wrote in message
news:enOqwmpzIHA.3496@TK2MSFTNGP03.phx.gbl:
| Quote: | 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@unknown.com | |
| | Posted: Sun Jun 15, 2008 11:36 am Post subject: Re: exceeding 65536 rows? | |
Thanks, though that is a expensive way to do it........
I wonder if the on-line Excel (or maybe the free spreadsheets) can go beyond
65,536.
Jeff
Ben M. Schorr - MVP (OneNote) wrote:
| Quote: | Yes. Upgrade to Excel 2007. :)
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? |
|
| |
| | | BobS | |
| | Posted: Sun Jun 15, 2008 1:40 pm Post subject: Re: exceeding 65536 rows? | |
| |  | |
"Jeff@unknown.com" <JeffMalka@orthohelp.com> wrote in message
news:enOqwmpzIHA.3496@TK2MSFTNGP03.phx.gbl...
| Quote: | 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:
LINK
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. |
| |
| | | Jeff@unknown.com | |
| | Posted: Sun Jun 15, 2008 2:16 pm Post subject: Re: exceeding 65536 rows? | |
| | | |
"BobS" <no-spam@noplace.com> wrote in message
news:ObazQ4vzIHA.2208@TK2MSFTNGP04.phx.gbl...
| Quote: |
"Jeff@unknown.com" <JeffMalka@orthohelp.com> wrote in message
news:enOqwmpzIHA.3496@TK2MSFTNGP03.phx.gbl...
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:
LINK
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 |
| |
| | | Pete_UK | |
| | Posted: Sun Jun 15, 2008 5:00 pm Post subject: Re: exceeding 65536 rows? | |
| | | |
Quattro Pro (part of Word Perfect Office from Corel) has had 1 million
row capability for many years - it is significantly cheaper than Excel
2007, so this might be a possible way forward for you.
Hope this helps.
Pete
On Jun 15, 5:16 pm, "J...@unknown.com" <JeffMa...@orthohelp.com>
wrote:
| Quote: | "BobS" <no-s...@noplace.com> wrote in message
news:ObazQ4vzIHA.2208@TK2MSFTNGP04.phx.gbl...
"J...@unknown.com" <JeffMa...@orthohelp.com> wrote in message
news:enOqwmpzIHA.3496@TK2MSFTNGP03.phx.gbl...
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:
LINK
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- Hide quoted text -
- Show quoted text - |
|
| |
| | | Ben M. Schorr - MVP (OneN | |
| | Posted: Sun Jun 15, 2008 5:25 pm Post subject: Re: exceeding 65536 rows? | |
| | | |
...Google's spreadsheets, by the way, are limited to 10,0000 rows.
--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
LINK
LINK
"Jeff@unknown.com" <JeffMalka@orthohelp.com> wrote in message
news:eFc27MwzIHA.4816@TK2MSFTNGP03.phx.gbl:
| Quote: | "BobS" <no-spam@noplace.com> wrote in message
news:ObazQ4vzIHA.2208@TK2MSFTNGP04.phx.gbl...
"Jeff@unknown.com" <JeffMalka@orthohelp.com> wrote in message
news:enOqwmpzIHA.3496@TK2MSFTNGP03.phx.gbl...
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:
LINK
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 |
|
| |
| | | Jeff@unknown.com | |
| | Posted: Sun Jun 15, 2008 7:46 pm Post subject: Re: exceeding 65536 rows? | |
| | | |
Guess that knocks them out......
Jeff
"Ben M. Schorr - MVP (OneNote)" <bens@bogusaddress.mvp> wrote in message
news:OPjOE2xzIHA.4492@TK2MSFTNGP02.phx.gbl...
| Quote: | ..Google's spreadsheets, by the way, are limited to 10,0000 rows.
--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
LINK
LINK
"Jeff@unknown.com" <JeffMalka@orthohelp.com> wrote in message
news:eFc27MwzIHA.4816@TK2MSFTNGP03.phx.gbl:
"BobS" <no-spam@noplace.com> wrote in message
news:ObazQ4vzIHA.2208@TK2MSFTNGP04.phx.gbl...
"Jeff@unknown.com" <JeffMalka@orthohelp.com> wrote in message
news:enOqwmpzIHA.3496@TK2MSFTNGP03.phx.gbl...
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:
LINK
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
|
|
| |
| | | Jeff@unknown.com | |
| | Posted: Sun Jun 15, 2008 7:47 pm Post subject: Re: exceeding 65536 rows? | |
| | | |
Thank you Pete. You are very helpful. I have an old version of Quattro Pro
somewhere. I'll dig it up and see.
Thanks.
"Pete_UK" <pashurst@auditel.net> wrote in message
news:6ba63f2a-5515-41eb-8a42-3cb5ecc237b2@c58g2000hsc.googlegroups.com...
Quattro Pro (part of Word Perfect Office from Corel) has had 1 million
row capability for many years - it is significantly cheaper than Excel
2007, so this might be a possible way forward for you.
Hope this helps.
Pete
On Jun 15, 5:16 pm, "J...@unknown.com" <JeffMa...@orthohelp.com>
wrote:
| Quote: | "BobS" <no-s...@noplace.com> wrote in message
news:ObazQ4vzIHA.2208@TK2MSFTNGP04.phx.gbl...
"J...@unknown.com" <JeffMa...@orthohelp.com> wrote in message
news:enOqwmpzIHA.3496@TK2MSFTNGP03.phx.gbl...
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:
LINK
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- Hide quoted text -
- Show quoted text - |
|
| |
| Page 1 of 2 .:. Goto page 1, 2 Next | |
|
|
