How to Update My PivotTable

[fergal]

Hi,

I would like to do something similar but cant get this script to work. Unfortunately I am far less advanced at VBA.

I have entered the script into to worksheet change code so hoped this would automatically update each time the field is changed. However nothing seems to happen at all.

any ideas?

F

** Edit **
This was moved from Updating Pivot Table Page Fields based on another page field.

[fergal]

Sorted it :-)

Works great if you put the code on the right sheet!

[NeoPa]

I don't know how I missed this at the time Fergal, but pleased to see you managed to get it resolved anyway :-)

Welcome to Bytes!