Solved

Pivot Table Drill Down to Detail

Posted on 2011-03-18
1
442 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:gdunn59
1 Comment
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 250 total points
ID: 35171636
This link uses vba code to specifically address your problem:
              http://msdn.microsoft.com/en-us/library/aa163801(v=office.10).aspx
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question