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
 
Top