I presume you have Excel 2007?

Open your .xls file in Excel 2007, save the file as an Excel 2007 file type
(.xlsw, .xlsx, etc) using File Save As. Close the file and reopen it you
should now have 2007's 1M+ rows available.

"Stan" wrote:

Hi,
can someone show me how to increase the maximum number of rows, more than
65,536?
thanks
Stan