Using variables with pivot tables

[Lorraine G]

I have a pivot table which I would like to control from a navigation sheet
i.e. I'd like to be able to change the values in the pivot using variables.
Is this possible?

[Roger Govier]

Hi Lorraine

If you are wanting to change the page fields in Pivot Tables, then you
will probably be able to adapt some of the code in one or other of the
tow downloads from Debra Dalgleish's site.

http://www.contextures.com/excelfiles.html#Pivot

http://www.contextures.com/PivotMultiPagesChange.zip
http://www.contextures.com/PivotPageSpinner.zip

--
Regards

Roger Govier


"Lorraine G" <Lorraine [email protected]> wrote in message
news:[email protected]...
>I have a pivot table which I would like to control from a navigation
>sheet
> i.e. I'd like to be able to change the values in the pivot using
> variables.
> Is this possible?

[Lorraine G]

Thanks for this, Roger. I think the MultiPagesChange code will work, but I
have two issues.

1. I am working with several pivots in different tabs and I need all of
them to be updated. I've tried playing around with the code to adapt it to
my situation, but I'm not too clued up with coding (only did Lotuscript many
moons ago), so any chance of some help to get me on the right track.
2. I not only need to change the results of the page, but would also like
to change the results where the same field is in a row in one of the other
pivots. Do you think this is possible?

"Roger Govier" wrote:

> Hi Lorraine
>
> If you are wanting to change the page fields in Pivot Tables, then you
> will probably be able to adapt some of the code in one or other of the
> tow downloads from Debra Dalgleish's site.
>
> http://www.contextures.com/excelfiles.html#Pivot
>
> http://www.contextures.com/PivotMultiPagesChange.zip
> http://www.contextures.com/PivotPageSpinner.zip
>
> --
> Regards
>
> Roger Govier
>
>
> "Lorraine G" <Lorraine [email protected]> wrote in message
> news:[email protected]...
> >I have a pivot table which I would like to control from a navigation
> >sheet
> > i.e. I'd like to be able to change the values in the pivot using
> > variables.
> > Is this possible?
>
>
>