Excel 2007 with no increase in rows and columns

  • Thread starter Harlan Messinger
  • Start date
H

Harlan Messinger

My Excel 2007 has only 65,536 rows and 256 columns just as my older
versions had. I'm told that it's supposed to have increased these
numbers to 1,048,576 and 1,024, respectively. It's version
12.0.6504.5001 SP2, with Microsoft Office version 12.0.6425.1000. Any ideas?
 
G

Gord Dibben

Excel 2007 New workbooks have the increased rows and columns.

Presumably you are opening older version workbooks in 2007.

These will have only the 256 columns and 65536 rows.

After opening, save as a 2007 workbook, close and reopen and you will get
the increase in rows and columns,


Gord Dibben MS Excel MVP
 

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

What is the Excel 2007 rows limit for Excel 2003 macros? 0
Importing CSV file with more than 65535 rows to Excel 2007 9
Trouble when trying to open a file excel 2007 in excel 2003 3
Excel 2007 rows & columns 3
how to increase no. of rows in excel spreadsheet 2
Maximun number of rows and columns 3
Number of rows in Excel 2007 worksheets 3
Where are the extra columns and rows? 6

Top