Excel 2007 - million rows

M

maureen

I have the new Excel 2007, but in only shows 65,536 rows. How can I get to
to show a million rows?
 
B

Bernard Liengme

You must be working in compatibility mode. Did you open an old XLS file?
Close it and use File | Open New
best wishes
 
N

Niek Otten

Or, if it was an old file, Save as...Excel workbook (xlsx), close and re-open

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| You must be working in compatibility mode. Did you open an old XLS file?
| Close it and use File | Open New
| best wishes
| --
| Bernard V Liengme
| Microsoft Excel MVP
| www.stfx.ca/people/bliengme
| remove caps from email
|
| | >I have the new Excel 2007, but in only shows 65,536 rows. How can I get to
| > to show a million rows?
|
|
 

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

Compatability Mode 1
Number of rows in Excel 2007 worksheets 3
What is the Excel 2007 rows limit for Excel 2003 macros? 0
Adding more than 65,536 rows in Excel 2007 5
How to have more than 65,000 rows in excel 2007 3
maximum number of rows in Excel 2007 2
Excel 2007 with no increase in rows and columns 2
saving files 1

Top