I have an excel file which has more than 65536 rows. However, I can see only first 65536 of them. Is it possible to see all of them in Excel 2007?
+8
A:
According to this MSDN entry, the limit is 1 million rows. You could be running in compatibility mode, which would limit you to the old standard of 65k. Does your excel say compatibility mode in the title? If so, you can save the file as a new style file under the "save as" menu, or change your default to always use the 2007 file standard.
Knox
2008-10-13 14:30:56
Yes, it says "compatibility mode".But "save as" in xslx doesn't work, because new file will only have 65536 rows saved, so all following rows that were in original file will be lost.Can I open the old file without compatibility mode?
Delynx
2008-10-13 14:43:32
it doesn't make sense that the old file was an xls with more than 65k rows... Could it be an comma delimited file, csv filetype? If so, change your default to the xslx format, and then I believe you'll be able to open the old file in the new style. If it was xls, what generated the file? Not Excel!
Knox
2008-10-13 15:15:47
+13
A:
Here is an interesting blog entry about numbers / limitations of Excel 2007. According to the author the new limit is approximately one million rows.
Sounds like you have a pre-Excel 2007 workbook open in Excel 2007 in compatibility mode (look in the title bar and see if it says compatibility mode). If so, the workbook has 65,536 rows, not 1,048,576. You can save the workbook as an Excel workbook which will be in Excel 2007 format, close the workbook and re-open it.
splattne
2008-10-13 14:32:25
+1
A:
I have found that the 65536 limit still applies to pivot tables, even in Excel 2007.
Mark Ransom
2008-10-13 14:53:30
+1
A:
I am not 100% sure where all of the other suggestions are trying to go, but the issue is basically related to the extension that you have on the file. If you save the file as a Excel 97/2003 workbook it will not allow you to see all million rows. Create a new sheet and save it as a workbook and you will see all million. Note: the extension will be .xlsx
Joe
2008-10-13 20:56:51
A:
Excel 2003, doesn't included 1M row features, Introduced in 2007 onwards.
In Excel2007, save as "normal" Excel file, not a backwards compatible one.
You may have to close and re-open Excel to get the full 1M rows
Thilip
THILIP
2010-06-25 15:51:39