If your workbook is already formatted up, you can also do this:
Use Save As to save a copy of the file in one of the Excel 2007 formats,
then close the file and open the new copy of it. It should open in native
Excel 2007 mode, not compatibility mode.

"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?