Number of rows in Excel 2007

  • Thread starter Thread starter Gilles Desjardins
  • Start date Start date
G

Gilles Desjardins

Hi everyone, I was under the impression that Excel 2007 was going to have
more than 1 million rows and 16,000 columns. I opened the program last week
at work and saw only the regular 65,536 just like previous versions.

Am I dreaming, did I invent in my own mind?

Your comments will be appreciated.

Gilles
 
If your workbook is an xls workbook, then only 65,536 rows show. Save as an
xlsx and it will have the million rows.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 

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: Huge Spreadsheets (>1 Million Rows, 16,000 Columns) 14
Compatability Mode 1
What is the Excel 2007 rows limit for Excel 2003 macros? 0
Number of rows in Excel 2007 worksheets 3
Excel 2007 - million rows 2
How can I see more than 65,536 rows in Excel 2007? 2
grouping up in Excel 2007 1
Excel 2007 with no increase in rows and columns 2

Back
Top