+ Reply to Thread
Results 1 to 3 of 3

Row Limit 65536

  1. #1
    Mainframer at Heart
    Guest

    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.

  2. #2
    Gord Dibben
    Guest

    Re: Row Limit 65536

    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
    Heart@discussions.microsoft.com> 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.



  3. #3
    Mainframer at Heart
    Guest

    Re: Row Limit 65536

    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
    > Heart@discussions.microsoft.com> 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.

    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1