Rick

You can use the Worksheet_Calculate event. This will fire when the pivot
table page is changed (in fact, any time the worksheet is calculated). In
it, you can check the value of the page field and change the formula if
needed.

To code in that event, right click on the sheet tab and choose View Code.
Select Worksheet and Calculate from the drop down boxes at the top of the
pane to insert the Sub and End Sub statements, then code away.

I don't work with pivot tables very much, but if you have some questions
about how to get the page value or change the formula, post back with some
details.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Rick" wrote in message
...
Hi - I want to be able to change the formula in a
calculated field of a pivot table when the user updates
the table by choosing an item from a page field.

I know very, very little VBA, but can see by recording a
macro how the formula is changed. What I need help with
is how to do this dynamically when the user changes the
pivot table.

Any help would be appreciated !

thx,

Rick