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

Dumb question alert! What program to use? 0
DGET only limited to 1000 Rows, but I need 8000 rows for DGET funt 1
Sharing Access MDB or Accdb with client using older or newer version of Office 1
Importing Crystal Reports into Excel 2007 possible? 0
Need Help with Macro Security 1
How to have more than 65,000 rows in excel 2007 2
Excel Office 2007 and maximum rows 2
Weighted % Complete calculation 1

Top