L
Lindsey
I have a lot of data and I need about 300K rows, is there a way I can get
more? Thanks!
more? Thanks!
M
Michelle Mathews
Hi Lindsay,
What version of Excel are you using?
Excel 2003 has 65,536 rows
Excel 2007 has 1,048,576 rows
What version of Excel are you using?
Excel 2003 has 65,536 rows
Excel 2007 has 1,048,576 rows
F
FSt1
hi
if you have 2007 then you have 1,048,576 rows and 16,384 columns.
if you have 2003 or lower, then you have 65536 and 256 columns and no way to
increase that.
regards
FSt1
if you have 2007 then you have 1,048,576 rows and 16,384 columns.
if you have 2003 or lower, then you have 65536 and 256 columns and no way to
increase that.
regards
FSt1
M
Mike H
Buy Excel 2007
L
Lindsey
Yes, I have the 2003. I wish I had 2007, but it is not my choice. 
M
Mike H
Then you'll have to do with the rows you have
Lindsey said:Yes, I have the 2003. I wish I had 2007, but it is not my choice.
J
Jim Thomlinson
If you can use a pivot table then you are not limited to 65k rows. The pivot
cache is only bounded by memory so you can potentially have over a million
rows in xl2003...
cache is only bounded by memory so you can potentially have over a million
rows in xl2003...
M
Michelle Mathews
If you have Excel 2003 and you are limited to 65,536 rows you might think of
using a Pivot Table.
using a Pivot Table.
S
Sean Timmons
You can use MS Access. Many rows available there. Depends on what you are
trying to accomplish.
trying to accomplish.