software

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.

www.contextures.com/excelfiles.html#Pivot

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

--
Regards

Roger Govierquot;Lorraine Gquot; lt;Lorraine gt; wrote in message
...
gt;I have a pivot table which I would like to control from a navigation
gt;sheet
gt; i.e. I'd like to be able to change the values in the pivot using
gt; variables.
gt; 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?

quot;Roger Govierquot; wrote:

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