How can i open an MS Excel file which has more than 65000 rows of data.?

Question

How can i open an MS Excel file which has more than 65000 rows of data.

When i tried opening the file, Excel is is discarding the rows after 65000 and not able to see the remining rows.

Please help me...

Answer 1

is the file extension xls or csv?

there is no limit on the number of rows in a csv, but excel has a 65536 row limit on xls files.

there really is nothing you can do in excel because excel simply will not display that many rows. excel has a maximum of 2^16 or 65536 rows because each row is identified by a 2-byte integer.

try going into access and importing it into a new table. for example, go to access, create a new blank database. then file \ get external data \ import. if you have a csv, choose "text files" and if you have an xls, choose "microsoft excel" under files of type. just click next, next, next on the wizard that pops up.

Answer 2

WOW that's a HUGE file, i never ever needed more then a few hundreds of rows even in my professional use, try open office maybe that program does allow more then 65000 rows (doubt it)

http://www.openoffice.org

Answer 3

Excel has a HARD limit of ~65k rows. If you have data with more rows than that - use Access. I believe that it has a limit of >2million.

If you prefer Excel, put all the data in Access, then sort it to a more manageable number of rows.

Answer 4

If you can't open (or create) that many rows, how did you create a file with that many rows in the first place? Are you sure that the file you have does in fact have that many rows?

Answer 5

Visit This Incredible Mall ===> http://market.w3org.pw/himt9

Answer 6

I don't think you can. The limit is 65,536 rows by 256 columns.

Answer 7

try it to search in vbcode.com.
there is a way.