About Excel 1,000,000 rows

D

dacarica

When i run importing data from external source i still got the message that
maximum rows 65536 excided? is there some parameter to set?
 
P

Per Jessen

Hi

Upgrad to excel 2007 it have a maximum of 1,048,576 rows.

As you have already experienced older versions of excel have a maximum of
65536 rows.

Best regards,
Per
 
P

Peo Sjoblom

Assuming you already have Excel 2007, then save the workbooks in 2007 format
(xlsx if there are no macros) and close and reopen Excel


--


Regards,


Peo Sjoblom
 

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

Need Help with a VBA subroutine 0
Excel file linked to external source 0
Need Help with Macro Security 1
How do I get more rows than 66,000 rows? 4
You'll need a new app to open this about link 1
Help needed for inserting a row. 0
Remove Identical words 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top