Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 rows
how do I show all 1 million rows only showing 65,000
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 rows
You need to use the native file format, if you open a workbook created in a
previous version 2007 will automatically use the compatibility file format xls and thus will only showing the number of rows of 97-2003, if you save it as a 2007 workbook *xlsx it should show all rows -- Regards, Peo Sjoblom "Finney" wrote in message ... how do I show all 1 million rows only showing 65,000 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 rows
If you save an existing file as an Excel 2007 file type, you will have to
close and reopen the file to turn off compatability mode and have all 1,048,576 rows available (or at least I haven't found a better way...). "Finney" wrote: how do I show all 1 million rows only showing 65,000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding more than 65,536 rows in Excel 2007 | Excel Discussion (Misc queries) | |||
How can I see more than 65,536 rows in Excel 2007? | Setting up and Configuration of Excel | |||
Excel 2007 - million rows | Excel Discussion (Misc queries) | |||
Excel 2007 rows & columns | Excel Discussion (Misc queries) | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) |