Extending worksheet row number

  • Thread starter Thread starter SirJohn
  • Start date Start date
S

SirJohn

Hi all,

I have a big problem.
I have to import a 120.000 lines text file into a excell worksheet...
But! an worksheet has only 65535 lines... :confused:

Is it any way to have more lines in an excel worksheet?

All the best to you!
 
Why confused. Everything has its limits and Excel has a limit of 65535 rows.
Use either Access or QuattroPro
Or spread the data over a number of sheets.

Sorry, Sir John, I cannot give you more consolation.
Your obedient serf
Bernard
 

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

Excel 2007 SP1 - How to correct scrollbar extent? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Blank Sheet with Gridlines 11
Cannot copy worksheet to another file 2
How do I import data from a text file into Excel 2003 2
Matching records based on a common field 1
Importing data from Excel worksheet into Excel template 2
Import Txt file over several excel sheets 2

Back
Top