Where are the extra columns and rows?

F

frankoamerican

Hi-

In 2007, there are supposedly available over a million rows and over 16000
columns, but all I've been able to get are the 256 by 65536 in all the other
excel versions.

So......what are I doing wrong?

Thanks for your help!
 
S

Sheeloo

Most likely you are still using an old file (XLS) format.

Use SAVE AS to save it into Excel 2007 format (XSLX) extension and you will
get the extra rows and columns.

You can also see the extra rows/columns if you open a new workbook.
 
S

Sheeloo

FYI - in Excel 2007 (I am sure you know this... this if for the benefit of
other users)

XLSM is for workbooks with macros...

XLSX is used for workbooks without macros.
 
F

frankoamerican

Thank you!

Sheeloo said:
FYI - in Excel 2007 (I am sure you know this... this if for the benefit of
other users)

XLSM is for workbooks with macros...

XLSX is used for workbooks without macros.
Click to expand...
 
D

Don Guillett

Incidentally, if you prefer, you may keep as an .xls file and work with it
in xl2007
 
Top