Too Few Rows in New Excel Workbook

In Excel 2007 and Excel 2010, when you create a new workbook, there should be 1,048,576 rows on the worksheet.

Excel2007NewSheet01

However, one of my clients was creating new files in Excel 2007, and the sheets only had 65,536 rows, just as they did in older versions.

Excel2007NewSheet03

Perhaps you don’t need more rows than that, but if you’ve paid for a shiny new version, you’d like access to all of its features!

Solve the Too Few Rows Problem

At first, we thought the problem might be an old Excel 2003 template, that was starting automatically, and being used for the new workbooks. A search of all the Templates folders didn’t turn up any suspects, so that theory was wrong.

Finally, we discovered that the default format for saving files was set to Excel 97-2003 Workbook (*.xls).

Excel2007NewSheet02

To get the full-sized Excel 2007 worksheets, go into the Excel Options, and in the Save category, select one of the newer formats as the default for saving files.

Excel2007NewSheet04

Click OK, to close the Options window, and when you create a new workbook, its sheets will have 1,048,576 rows.

___________

You may also like...

3 Responses

  1. Shairie says:

    That helps me until I close Excel. Then when I reopen it, it opens in Compatibility Mode and my Save Files in this Format reverts back to .xls. Any thoughts?

  2. Ninad says:

    Thanks. Had this issue and was struggling to solve it.

  3. Roger says:

    I have found with Excel 2010 that if I create a new workbook from teh file menu by going File-New-Create the new workbook opens with the expected 1048576 rows, but if I put the “new” button on the quick start menu, and click it, the new workbook opens with only 65536 rows!

    I checked in File-Options-Save and it is set to save files in *.xlsx format, so that’s not the problem.

    Does anyone know how to fix this problem?

Leave a Reply

Your email address will not be published. Required fields are marked *