Excel never had a row limit of 32767

Excel jumped from 16384 to 65536 with the introduction of Excel 97.

The macro on this MS page imports 65536 rows to a sheet.

http://support.microsoft.com/default...;en-us;Q120596


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 15:00:01 -0700, Mainframer at Heart <Mainframer at
wrote:

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.