Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Pivot Table Drill Down to Detail

Posted on 2011-03-18
1
Medium Priority
?
450 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 1000 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 recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

578 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