increase total rows

S

Stan

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

JLatham

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.
 
S

Stan

Thanks!!!

JLatham said:
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.
Click to expand...
 

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

Row Limitation 4
need a large spreadsheet 6
Increase rows in worksheet beyond 65,536 row limit 2
What is the Excel 2007 rows limit for Excel 2003 macros? 0
exceed maximum rows 3
Not Enough Rows in Excel 6
Outlook Outlook 2
Excel 2007 - million rows 2

Top