Number of rows in Excel 2007

  • Thread starter Gilles Desjardins
  • 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
 
B

Bob Flanagan

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
Excel 2007 - million rows 2
Number of rows in Excel 2007 worksheets 3
Excel 2007 with no increase in rows and columns 2
How can I see more than 65,536 rows in Excel 2007? 2
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1

Top