Is it possible to have rows above 65,000 in Excel 2007

[Nyota]

Sponsored Links

I am using excel 2007. In worksheet i have only 65,000 rows. I have heard that excel 2007 can provide over a million rows. Can some one help me on how to get all the rows (over a million rows) in excel 2007. Looking foward to hear from you.

[Shurod]

You can do that by Save as .xlsx; and try reopening the file. I do not know the exact way, but I think is the actual limitation of Excel. You can try a new spreadsheet in place of same.

[Panop]

Or esle there is one more thing you can try. Click on Office button > Excel Options > "Save" section - make sure the top dropdown doesn't say ".xls", but says ".xlsx" or ".xlsm" etc. All new workbooks will not have 1048576 rows. If you're opening a file which was created in 2003 or earlier, then you still will get 65536 rows. To increase this yuo need to convert it to 2007: Office button/Convert.