Where are the extra columns and rows?

[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!

 

[Don Guillett]

You need to save your file as an .xlsm>close it>open it

 

[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.

 

[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.

 

[frankoamerican]

Thank you!

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.

 

[frankoamerican]

Thank you, Don!

You need to save your file as an .xlsm>close it>open it

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

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