How do I get beyond the upper limit of 65,500 records on Excel?

How do I get beyond the upper limit of 65,500 records on Excel?

I have a lot of csv files in text that I routinely convert to Excel files,
and sometimes Excel chokes on the size if it gets beyond a certain amount of
rows.

Is there a way of getting around this?
I need to be able to display the rows too, besides being able to work with
them.

- Nicholas

Hi Nicholas,

See MSKB Knowledge Base Article # 120596

http://support.microsoft.com/default...b;en-us;120596


---
Regards,
Norman



"Nicholas Korsakov" <Nicholas [email protected]> wrote in
message news:[email protected]...
> How do I get beyond the upper limit of 65,500 records on Excel?
>
> I have a lot of csv files in text that I routinely convert to Excel files,
> and sometimes Excel chokes on the size if it gets beyond a certain amount
> of
> rows.
>
> Is there a way of getting around this?
> I need to be able to display the rows too, besides being able to work with
> them.
>
> - Nicholas

That may be one of the most useful macros I have found. For months I have been splitting the CSV file using notepad then saving them as seperate files.

The irony is that now I have a solution, I don't need it because i have a new job any it is someone elses problem.

Now THAT is funny. Best of luck in your new job, Swedish Max !
--
RMC,CPA


"swedish max" <[email protected]> wrote in message
news:[email protected]...

That may be one of the most useful macros I have found. For months I
have been splitting the CSV file using notepad then saving them as
seperate files.

The irony is that now I have a solution, I don't need it because i have
a new job any it is someone elses problem.


--
swedish max
------------------------------------------------------------------------
swedish max's Profile: http://www.excelforum.com/member.php...o&userid=24408
View this thread: http://www.excelforum.com/showthread...hreadid=472121