Pivot Table Drill Down to Detail
Posted on 2011-03-18
I have an excel spreadsheet where I have pasted in data for the detail, and created several different tabs/pivot tables from the detail data.
After creating all the pivot tables, if I go back to the main tab that contains the collapsed categories that the pivot tables are constructed from, and double-click on the count field it brings up the detail for whatever particular count I double-click on. The only problem is that it creates a new tab each time I do this.
Is there anyway to go to the existing pivot tables that I originally created when double clicking on the count, instead of it creating a new pivot table/tab each time?