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

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

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

Many Thanks.


--
morchard
------------------------------------------------------------------------
morchard's Profile: http://www.excelforum.com/member.php...o&userid=24761
View this thread: http://www.excelforum.com/showthread...hreadid=383306