When I open a new Excel 2007 worksheet, it has only 65,536 rows and
256 columns. The title of the worksheet says "(Compatability Mode).

How do I open a true Excel 2007 worksheet with 1+ million rows and
16,000+ columns?

This typically happens when you open a XLS (Excel 97-2003) file...

Try to SAVE AS Excel Workbook (*.xlsx) ...

Probably you are carrying over (from Excel 2003) your default personal.xls,
book.xlt, sheet.xlt ... which dictate your default workboo/worksheet to open
in compatibility mode.


See http://office.microsoft.com/en-us/ex...292861033.aspx

"GARY" wrote:

When I open a new Excel 2007 worksheet, it has only 65,536 rows and
256 columns. The title of the worksheet says "(Compatability Mode).

How do I open a true Excel 2007 worksheet with 1+ million rows and
16,000+ columns?