Results 1 to 5 of 5

Create Pivot table with data from 2 or more different spread sheets?

This is a discussion on Create Pivot table with data from 2 or more different spread sheets? within the Excel Questions forums, part of the Question Forums category; For my job I get sent large spread sheets with about 35,000 raws of data. Each spread sheet is the ...

  1. #1
    New Member
    Join Date
    Sep 2012
    Posts
    8

    Default Create Pivot table with data from 2 or more different spread sheets?

    For my job I get sent large spread sheets with about 35,000 raws of data. Each spread sheet is the same layout and column headings.

    I have been putting the data into the same spread sheet and using a pivot table to extract the data I need (that is from the overall data and not just one spread sheet). But this spread sheet where I have been getting the data is getting to large. So ideally is there a way I can insert data from different spread sheets into a pivot table? I looked into this and can link data from different tabs or sheets. But not different spread sheets/work books.

    I would say I have good to advanced excel skills. I don't know VBA, but can edit the code if given instructions.

    Thanks

  2. #2
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    7,851

    Default Re: Create Pivot table with data from 2 or more different spread sheets?

    welcome

    there is explanation http://www.mrexcel.com/forum/excel-questions/315768 and other places - please google

    you don't need VBA; the old thread [note Excel 2003] initially answers a specific question asking for a VBA solution; later in the thread is discussion about solutions without code

    cheers

  3. #3
    New Member
    Join Date
    Sep 2012
    Posts
    8

    Default Re: Create Pivot table with data from 2 or more different spread sheets?

    Thanks for the response - but the link doesn't work.

    I have searched into this issue - but not found any solutions as yet.

    I found the link below but the macro is not working for me in excel 2010.

    Pivot Table From Data in Multiple Workbooks

  4. #4
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    7,851

    Default Re: Create Pivot table with data from 2 or more different spread sheets?

    Try again
    http://www.mrexcel.com/forum/excel-questions/315768-creating-pivot-table-multiple-sheets.html

    As I wrote already, that old thread (initially) addresses a particular request for a code solution. Further in the thread is other information. To change the code for later versions is minor, btw, and is likely just the connection string but I can' test that as I use Excel 2003 exclusively. But you don't need code to make the pivot table it is easy enough manually.

  5. #5
    New Member
    Join Date
    Sep 2012
    Posts
    8

    Default Re: Create Pivot table with data from 2 or more different spread sheets?

    Thanks Fazza - sorry its been a while since I logged in. So a delayed thanks!

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com