It sounds like it is running in compatibility mode. Look at the top of the
Excel window when you have the Excel file you are trying to pull the data
into open - if it says filename.xls [Compatibility Mode] then you'll know
for sure. In that mode it is limiting sheet size by Excel 2003 rules (64K x
255).

Start a new workbook - it should then say 'Book1' without the [Compatibility
Mode] notice and you should be able to import the data.


"jason2444" wrote:

have a text file that is a little over 250,000 lines and will be 13 columns
wide. I can open the whole file in excel but if I try and import it using ,
as a delimiter to put all the text in the right columns it says file is to
large for on sheet. and will not let me import the whole file. any one have
a solution so i can import the entire file? or have any suggestion why this
is happening?