Row Limit 65536

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.

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
[email protected]> 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.

Thank you this was really helpful. I'll have to modify this to parse the data
into the cells, because my users aren't going to be able to deal with the
'Text To Columns' splitting for all the files we send them.

"Gord Dibben" wrote:

> 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
> [email protected]> 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.
>
>