Need more rows

  • Thread starter Thread starter Lindsey
  • Start date Start date
L

Lindsey

I have a lot of data and I need about 300K rows, is there a way I can get
more? Thanks!
 
Hi Lindsay,
What version of Excel are you using?
Excel 2003 has 65,536 rows
Excel 2007 has 1,048,576 rows
 
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 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...
 
If you have Excel 2003 and you are limited to 65,536 rows you might think of
using a Pivot Table.
 
You can use MS Access. Many rows available there. Depends on what you are
trying to accomplish.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graphs creating huge file size 4
Excel Help to copy information from one row at a time to another sheet 1
How do I remove duplicated information in 2 columns of Excel? 1
How to filter rows data based on background color of individual cells 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Grouping Data in Excel 1
Dynamic URL for first column of data from excel query? 1
performance issue filtering data table... 6

Back
Top