The EXCEL Help says that when importing a file exceeding exceeding 65536 you
can import the rest in another worksheet by setting a new range. However, in
doing so, it doestn't let you start at row 65537, the max it allows for the
next starting range is the old 32767 limit. When using that it doesn't
import 65k, it only import another 32K, so you get essentially repetitive
data on the second worksheet. Is there some way to get around this? My
users don't want to use a file splitter or Access or any other database.
They like Excel.