Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table with lots of data (2002)

    Is Excel able to import data directly to a Pivot Table where the number of records exceeds 65,536? If not, how else could this data be handled in Excel?

    Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Table with lots of data (2002)

    The first step of the Pivot Table Wizard lets you specify that you want to use an external data source, for example a database table or query. The external data source can hold more than 65,536 records.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table with lots of data (2002)

    Thank you.

  4. #4
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table with lots of data (2002)

    Supposing you had two Excel lists on separate worksheets, where each ran to, for example, 50,000 rows. Is there anyway to construct a Pivot Table based on both sets of data? I thought this might use the Multiple Consolidation Range option, but this seems to require duplicated row headings.. Andy.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Table with lots of data (2002)

    I don't think multiple consolidation ranges will do what you want. I'd go for an external data source.

Posting Permissions

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