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

frankoamerican

Thank you, Don!
Don Guillett said:
You need to save your file as an .xlsm>close it>open it

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Click to expand...
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 rows & columns 3
Maximun number of rows and columns 3
how to increase no. of rows in excel spreadsheet 2
I cannot delete the extra rows or columns in Excel 2007 2
Excel 2007 with no increase in rows and columns 2
How to have more than 65,000 rows in excel 2007 3
With the new file formats in Excel 2007 what are the worksheet dim 1
Deleting Rows and columns 2

Top