Row Limit in Excel

[Guest]

I work a lot with excel and I know that the row limit is 65,536, but I need
more than that. Is there any way to make the number of rows infinite or at
least to give me a certain amount of more rows. If there is please let me
know. Thank you.

 

[Paul B]

Molly, that is all there is, per sheet.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[JulieD]

Hi Molly

unfortunately a limit is a limit

suggested options are
1) use a database program rather than excel (ie access)
2) check out quattro pro as i belive it has a lot more rows (i think it's
1,000,000)

Cheers
JulieD

 

[Guest]

Hey Molly,

I've run into the same problem, and at first it was kind of gratifying.
Remember that commercial where the guy is surfing the internet, and the
computer comes on and says "You've reached the end of the internet". That's
how I felt the first time this happened to me.

To my knowledge, the limit is the limit. What I did was create a new
spreadsheet/wookbook, and copy or link the data in the maxed out spreadsheet
to the new one.

Dennis

 

[Bill Sharpe]

Sometimes the people at MS actually have good ideas. The row limit is
one of them. They're essentially trying to suggest that if you have more
than 65,536 lines of data in your spreadsheet that perhaps you should be
using some other program, such as a database. In earlier versions of
various spreadsheets the limit was 2048, 4096, 8192, and 16384 rows(all
powers of two).

Corel's Quattro Pro, as another poster has suggested, lets you go up to
a million rows if you insist.

You will spend way too much time trying to fill an infinite number of
rows!

Bill

I work a lot with excel and I know that the row limit is 65,536, but I
need
more than that. Is there any way to make the number of rows infinite or
at
least to give me a certain amount of more rows. If there is please let
me
know. Thank you.