Excel 2007 rows
how do I show all 1 million rows only showing 65,000
|
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 |
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 |
All times are GMT +1. The time now is 10:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com