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.
Bookmarks