ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   About Excel 1,000,000 rows (https://www.excelbanter.com/new-users-excel/195537-about-excel-1-000-000-rows.html)

dacarica

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

Per Jessen

About Excel 1,000,000 rows
 
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

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



Peo Sjoblom

About Excel 1,000,000 rows
 
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



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





All times are GMT +1. The time now is 06:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com