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

"Malaki" wrote in message
...
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