Combine 2 Pivot Tables into 1 Master Workbook?

[DANIEL 602]

Sponsored Links

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.

[Chitesh]

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.