ExcelBanter - How do I increase the limit on the number of import rows in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I increase the limit on the number of import rows in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/18247-how-do-i-increase-limit-number-import-rows-excel.html)

Aleck

How do I increase the limit on the number of import rows in Excel

Hi,

Does anyone know how to increase the number of rows that Excel can import or
read? My version is XP pro. Now the limit is about 65000 rows. I have data
sheet that is much more than that. Thank you.

Aleck

hi,
65536 is the max. hard coded into excel.
in xl help type specifications for more details

-----Original Message-----
Hi,

Does anyone know how to increase the number of rows that
Excel can import or
read? My version is XP pro. Now the limit is about 65000
rows. I have data
sheet that is much more than that. Thank you.

Aleck
.

Kassie

You could split your data into 2 or more sheets

"Aleck" wrote:

Hi,

Does anyone know how to increase the number of rows that Excel can import or
read? My version is XP pro. Now the limit is about 65000 rows. I have data
sheet that is much more than that. Thank you.

Aleck

All times are GMT +1. The time now is 06:33 AM.