input file with more than 250000 lines

  • Thread starter Thread starter green1111
  • Start date Start date
G

green1111

I need to work with input file with more than 250,000 lines but Excel
allow me to take in data with less than 65,000 lines only. How to
sslice my data in 5 worksheet so that I can work with my data ? Is
there any work around ? Thanks....
 
This link leads to code from Bernie Deitrick

http://redirx.com/?334z

--
Kind regards,

Niek Otten

|
| I need to work with input file with more than 250,000 lines but Excel
| allow me to take in data with less than 65,000 lines only. How to
| sslice my data in 5 worksheet so that I can work with my data ? Is
| there any work around ? Thanks....
|
|
| --
| green1111
| ------------------------------------------------------------------------
| green1111's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33863
| View this thread: http://www.excelforum.com/showthread.php?threadid=536414
|
 

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

need more than 65,000 lines 6
Worksheet row limitations. 2
AI could eliminate 250,000 public sector jobs within 15 years 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Sorting a csv 2
How increase max # of rows/sheet in excel? 1
Using PivotTables with > 65,000 rows 2
Help with data validation 1

Back
Top