My list is too long. Cannot be opened completely in xcl.
 

I have a text list of 1.3 million lines.
When opening themin excel , excel opens on part of the list.
Anybody ever overcome that?
--
capxc

My list is too long. Cannot be opened completely in xcl.
 

Have you tried Access? What kind of cell manipulation are you trying to do.
If your desire is really just to do queries, sorts, and cuts of the list, you
might seriously consider using Access.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"capxc" wrote:

I have a text list of 1.3 million lines.
When opening themin excel , excel opens on part of the list.
Anybody ever overcome that?
--
capxc

My list is too long. Cannot be opened completely in xcl.
 

I will try it and let you know.
--
capxc


"M Kan" wrote:

Have you tried Access? What kind of cell manipulation are you trying to do.
If your desire is really just to do queries, sorts, and cuts of the list, you
might seriously consider using Access.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"capxc" wrote:

I have a text list of 1.3 million lines.
When opening themin excel , excel opens on part of the list.
Anybody ever overcome that?
--
capxc