too many columns/rows for excel to hadle

[feerc]

I am trying to load .csv files into Excel with large amounts of data.
have run into the 364 column limit and the 65536 row limit. Is ther
anyway to configure Excel to hadle more columns or rows.

I thought that previous versions (or maybe it was Lotus 123) used t
carry extra data over to subsequent tabs.

There is a work around for the row problem using a text editor t
divide the data into two seperate files, but I cannot use a text edito
to divide the columns

 

[Judy Freed]

This is a knowledge base article that explains how to use a macro to import
data with more that 256 columns. I have used this successfully in the past.

http://support.microsoft.com/default.aspx?scid=kb;en-us;272729&Product=xl2002

Judy Freed

 

[Paul]

I am trying to load .csv files into Excel with large amounts of data. I
have run into the 364 column limit and the 65536 row limit. Is there
anyway to configure Excel to hadle more columns or rows.

I thought that previous versions (or maybe it was Lotus 123) used to
carry extra data over to subsequent tabs.

There is a work around for the row problem using a text editor to
divide the data into two seperate files, but I cannot use a text editor
to divide the columns.

Excel is fixed at 256 columns (not 364) and 65536 rows per worksheet.
There's no way of extending this. You must either split the data across more
than one worksheet, or use another application such as Access.

 

[feerc]

My mistake, Excel is limited to 256 columns, my data has 364 columns