Total rows allowed on spreadsheet 2007 version

B

Babyjsmom

I have the 2007 upgrade for office and I am not able to go past 65,000 rows
in excel, however 2007 excel boasts over a million rows. Is there a setting
somewhere I need to set to allow for more lines?
 
E

Elkar

Only new workbooks created in 2007 will have 1,048,576 rows. Older workbooks
from 2003 or earlier will still have the 65,536 row limitation. Even if they
are converted to 2007 format.

HTH
Elkar
 

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

DGET only limited to 1000 Rows, but I need 8000 rows for DGET funt 1
How to have more than 65,000 rows in excel 2007 3
Excel 2003 to Excel 2007 Compatability 4
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas 4
grand totals in pivot table rows 5
How do I get my Excel 2007 worksheet to go beyond 65536 rows? 1
Excel Office 2007 and maximum rows 2
Opening an Excel 2007 file in Excel 2003 2

Top