Modifying pivot table from other page

  • Thread starter Thread starter Diego Arbe
  • Start date Start date
D

Diego Arbe

Is there any way to modify pivot table or pivot graph properdies from macro?
or from another page?

Let me explain the situation:

In both my pivot graph and pivot tables I show an item in the [Page Field]
area, the area on the top.
This one works as a filter for the data being shown.

I want to have that same drop down externally from the pivot table and have
it modify the data, OR as these are fized options, create buttons linked to
a marcro that would make the same result.

Thank you!

Regards,

Diego
 
Thank you Roger,

I modified it and it worked perfectly.

Regards,

Diego

Hi

Download this example file for Debra Dalgleish's site. It will show you
what you need to do.http://www.contextures.com/PivotMultiPagesDiffChange.zip
orhttp://www.contextures.com/PivotMultiPagesChange.zip

--
Regards

Roger Govier




Is there any way to modify pivot table or pivot graph properdies from
macro? or from another page?
Click to expand...
Let me explain the situation:
Click to expand...
In both my pivot graph and pivot tables I show an item in the [Page
Field] area, the area on the top.
This one works as a filter for the data being shown.
Click to expand...
I want to have that same drop down externally from the pivot table
and have it modify the data, OR as these are fized options, create
buttons linked to a marcro that would make the same result.
Click to expand...
Thank you!

Diego- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top