How to create a Pivot table from text file with more than 65000 rows?

M

morchard

Is there a way to create a pivot tabel where the source data is a tex
file with more than 65000 rows of data? Normnally I just import th
text file to excel and then create a pivot, but in this case I have to
many rows but don't want to lose data.

I guess I can use the create pivot tabel from external data sourc
function but could somone take me through the steps to do this from
large text file - if this is possible!

Many Thanks
 
Top