How to have more than 65,000 rows in excel 2007

M

Malaki

Hi there,

I'm using excel 2007. In worksheet i have only 65,000 rows. I have heard
that excel 2007 can provide over a million rows. Can some one help me on how
to get all the rows (over a million rows) in excel 2007?

Looking foward to hear from you.

Thanks

Malaki
 
B

Bob Umlas

Office button/Excel Options/"Save" section - make sure the top dropdown
doesn't say ".xls", but says ".xlsx" or ".xlsm" etc.
All new workbooks will not have 1048576 rows.
If you're opening a file which was created in 2003 or earlier, then you
still will get 65536 rows. To increase this yuo need to convert it to 2007:
Office button/Convert.

HTH
 
O

oliver.friedrich

Thanks, that did the trick!

Am Donnerstag, 3. September 2009 16:58:02 UTC+2 schrieb Jacob Skaria:
 

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 2003 to Excel 2007 Compatability 4
Sort more then 65,000 rows in Excel 2
Deleting rows in Excel 2007 using filters 1
Adding more than 65,536 rows in Excel 2007 5
maximum number of rows in Excel 2007 2
Deleting excess rows from a spreadsheet 1
Excel 2007 - million rows 2
Total rows allowed on spreadsheet 2007 version 1

Top