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

Is there a max number of columns that can be inserted in a sheet 4
Open an Excel file, it prompts 'Data may be missing' 1
Additional Rows and Columns in Excel 2007 1
Autonumber field in Excel that behaves the same as Access 0
Importing CSV file with more than 65535 rows to Excel 2007 7
how to increase no. of rows in excel spreadsheet 2
Matching Rows with Multiple Columns in Two Worksheets 0
Trouble when trying to open a file excel 2007 in excel 2003 3

Top