Is it possible to see more than 65536 rows in Excel 2007

Question

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

User · Answer

Yes  the new limit is approximately 1 million rows   http   blogs msdn com excel archive 2005 09 26 474258 aspx

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

Yes  the new limit is approximately 1 million rows   http   blogs msdn com excel archive 2005 09 26 474258 aspx

User · Answer

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

User · Answer

Yes  the new limit is approximately 1 million rows   http   blogs msdn com excel archive 2005 09 26 474258 aspx

User · Answer

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

User · Answer

I have found that the 65536 limit still applies to pivot tables  even in Excel 2007

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

I have found that the 65536 limit still applies to pivot tables  even in Excel 2007

User · Answer

Yes  the new limit is approximately 1 million rows   http   blogs msdn com excel archive 2005 09 26 474258 aspx

User · Answer

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

User · Answer

I have found that the 65536 limit still applies to pivot tables  even in Excel 2007

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

I have found that the 65536 limit still applies to pivot tables  even in Excel 2007

[excel] Is it possible to see more than 65536 rows in Excel 2007?

Examples related to excel