ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Total rows allowed on spreadsheet 2007 version (https://www.excelbanter.com/excel-worksheet-functions/196374-total-rows-allowed-spreadsheet-2007-version.html)

Babyjsmom

Total rows allowed on spreadsheet 2007 version
 
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?
--
Babyjsmom

Elkar

Total rows allowed on spreadsheet 2007 version
 
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


"Babyjsmom" wrote:

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?
--
Babyjsmom



All times are GMT +1. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com