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