Results 1 to 2 of 2

Thread: Combine 2 Pivot Tables into 1 Master Workbook?

  1. #1
    Join Date
    Jul 2006
    Posts
    273

    Combine 2 Pivot Tables into 1 Master Workbook?

    I have 2 Excel Workbooks with a master pivot table. The Pivots use a drop down list that I have created on a seperate sheet. Its set up this way so that 2 different managers can work on their own sheets without overwriting the other. This part works great and now what I want to do is that to have both of these seperate workbooks feed into a Master Worksheet for the Sr Exec. The Master Workbook will pull its data from the 2 Mgr workbooks. I have tried opening up a blank Workbook and using the Pivot Table Wizard but its not recognizing the files. How can I do this? Thanks.

  2. #2
    Join Date
    Nov 2005
    Posts
    48

    Re: Combine 2 Pivot Tables into 1 Master Workbook?

    Before trying anything keep a backup with you. It is better if you stay on the safer side. Because if there is any issue with the file your data is not lost. It looks a bit complicated to me. It does not look that after combining you might get the results as you are expecting. You have to begin with merging the tables. That would be helpful.

Similar Threads

  1. How to merge 2 pivot tables in Excel
    By Rao's in forum Windows Software
    Replies: 2
    Last Post: 07-01-2012, 04:18 PM
  2. Filtering all pivot tables using the same criteria
    By Kanwaljeet in forum Windows Software
    Replies: 9
    Last Post: 28-07-2011, 12:08 PM
  3. Issue while inserting pivot Tables in Excel 2003
    By Clemens in forum Windows Software
    Replies: 3
    Last Post: 29-04-2009, 04:30 PM
  4. Pivot Tables in Excel 2007
    By dixiesky in forum Windows Software
    Replies: 4
    Last Post: 10-04-2009, 11:40 AM
  5. Replies: 3
    Last Post: 15-02-2008, 01:45 AM

Posting Permissions

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