file not loaded completely

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a ascii file .txt. It contains around 180.000 row data
When I try to open it in excel, there was an error "file not loaded completely"
Can anyone help to handle this
Thanks
 
Hi
Excel has a limit of 65536 rows per worksheet. No way around this. One
workaround:
- open the file with a text editor
- split this file into 3 parts of 60000 rows each
- import these three files separately to three different worksheets
 
You must log in or register to reply here.

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

how to split a large excel file into multiple smaller exel files. 3
Excel2007 - More columns when importing ascii file? 2
Convert Excel file ti ASCII format to allow a SIFT transfer 1
Worksheet row limitations. 2
Saving text with commas in a .csv file then converting to a .txt f 3
File not loaded completely Error 1
my files won't load completely in excel 1
Multiple Text files into one worksheet-need help 2

Back
Top