Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Combine 2 Pivot Tables into 1 Master Workbook?

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 07-11-2008
Member
 
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.

Reply With Quote
  #2  
Old 04-02-2013
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Combine 2 Pivot Tables into 1 Master Workbook?"
Thread Thread Starter Forum Replies Last Post
How to merge 2 pivot tables in Excel Rao's Windows Software 2 07-01-2012 05:18 PM
Filtering all pivot tables using the same criteria Kanwaljeet Windows Software 9 28-07-2011 01:08 PM
Issue while inserting pivot Tables in Excel 2003 Clemens Windows Software 3 29-04-2009 05:30 PM
Pivot Tables in Excel 2007 dixiesky Windows Software 4 10-04-2009 12:40 PM
Exporting project information to excel pivot table and workbook Itsme Microsoft Project 3 15-02-2008 02:45 AM


All times are GMT +5.5. The time now is 03:00 AM.