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

  • Thread starter Thread starter Malaki
  • Start date Start date
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
 
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
 
Thanks, that did the trick!

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