If you import the data using the <data<Import external data and selecting
your file
One of the entries is "start import at row"
this is not perfect and it often still wont go far enough but it at least
lets you go to another sheet I have had it tell me different max numbers for
the allowable start point before.

I have also had people write script for me to divide the data sets into
smaller chunks
and have used other programs such as Jump which would allow more rows and
just exported the size chunks I needed.

"rondajoy" wrote:

Does anyone know how to get excel to add another worksheet to the workbook to
open a text file that has more rows than the excel limit of 65536?
Currently, I am just cutting from the text file in notebook and pasting into
multiple worksheets. I keep thinking there must be a faster way...