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?

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 wrote in message
...
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?

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 wrote in message
...
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?