gdunn59
asked on
Pivot Table Drill Down to Detail
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?
Thanks,
gdunn59
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?
Thanks,
gdunn59
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.