MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Reading Beyond 65536 rows


Posted by TRIPURANANDA VARAMBALLY on November 01, 2001 6:41 PM

Hi

I receive some Excel files which are more than 65536
rows in size. Is there any work around to read the
whole file.

Thanx
Anand


Posted by Anon on November 02, 2001 12:02 AM

You could not have received some Excel files containing more than 65,536 rows.
Excel files cannot be larger than 65,536 rows.

Posted by TRIPURANANDA VARAMBALLY on November 02, 2001 1:45 AM

Hi,

Thank you.
These files are downloaded (saved as Excel) from
SAP successfully and while opening these files
in Excel, I get a message 'loading in incomplete'
and it load only upto 65536 rows. From this I guess, these files contain more than 65536 lines
but not able to read.

Thanx
Anand

Posted by Joe Was on November 02, 2001 4:40 AM

The file may be an export from some other application, like access. If this is the case pull it up in the original application and query or parse the data. Excel is limited to the number of row, 65536. JSW

Posted by Mark W. on November 02, 2001 5:37 AM

What you have is a text file that probably has a
.csv extension. It is not a binary Excel worksheet
document. If by "read" you mean you want to
examine the contents of this file you can do
so by opening it in Word or some other text
editor.

You could also use the macro mentioned in the
Microsoft support document at...

http://support.microsoft.com/support/kb/articles/Q120/5/96.ASP

...but you'd need to change the macro to reflect
Excel's current row limit 65,536 from its prior
limit of 16,384.