Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I open a new file in Excel 2007, I can see only 65536 Rows, instead of
1048576 rows. How can see the maximum rows and columns in Excel 2007. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you're opening a file last saved in 2003, it will open in "compatibility
mode" which displays the same limits as xl2003. You need to convert it to the current format. Use Office Button/Convert. Note that this will delete the original. You'll then have all the cells. Bob Umlas Excel MVP "shanth" wrote in message ... When I open a new file in Excel 2007, I can see only 65536 Rows, instead of 1048576 rows. How can see the maximum rows and columns in Excel 2007. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you Bob, it worked.
"Bob Umlas" wrote: If you're opening a file last saved in 2003, it will open in "compatibility mode" which displays the same limits as xl2003. You need to convert it to the current format. Use Office Button/Convert. Note that this will delete the original. You'll then have all the cells. Bob Umlas Excel MVP "shanth" wrote in message ... When I open a new file in Excel 2007, I can see only 65536 Rows, instead of 1048576 rows. How can see the maximum rows and columns in Excel 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
The increase number of rows in Excel | Excel Discussion (Misc queries) | |||
Excel 2003 Workbook I want to convert to Excel 2007 | Excel Discussion (Misc queries) | |||
Where did my Publish to Excel Services go? | Setting up and Configuration of Excel | |||
Excel 2007 | Excel Discussion (Misc queries) | |||
print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) |