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?