MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Find the name of the pivot table on the activesheet

  Asked By: Gwendolyn    Date: Jan 04    Category: MS Office    Views: 1572

I have a workbook which I am creating several pivot tables on several
sheets, I want to hide some of the information in the pivot. I can do
everything with code, but I have not been able to figure out how to
tell which pivot is on the active sheet. If I use the index I can find
the name but I do not know which sheet it is on. Any help would be



2 Answers Found

Answer #1    Answered By: Adelaide Fischer     Answered On: Jan 04

If you want to know what sheet  the pivot  on the active  sheet is on you could


But I suspect your question is meant to be more complicated than that.

Answer #2    Answered By: Blake Smith     Answered On: Jan 04

Yes, I may need to explain further. I have about 8 sheets that I
create and put pivot  tables on. This is done after I pull data out of
an Oracle database with sql. The I create charts based on the tables.
This is all being done with code, but I am manually going in and hiding
some of the data fields if they contain no information  so my chart will
be less cluttered. I have a loop to determine which items need to be
turned off, but now I want to apply this to every pivot on every
sheet. I am using ActiveSheet to do the process of finding empty
values, but when I try to apply this loop to the next sheet  I need to
know the name of the pivot on that sheet. I am currently using the
name of the one that is on the sheet I am debugging on but I typed it
in manually. I could just hard code  the routine for each page bt I
would rather reuse the code and just apply it to each sheet.

Didn't find what you were looking for? Find more on Find the name of the pivot table on the activesheet Or get search suggestion and latest updates.