Hey,

Ok, so now I'm stuck with a basic pivotrefresh function. Everytime I refresh a pivot I need to select 4 values and un-select one which i was doing by following code

Please Login or Register  to view this content.
Now I still want to select the four values, however I want to hide more then one value (which I cant define as i did in this case). Can I use a code in which the pivot only selects p, q, r & s values and hides rest of the values??

Thanx 4 any help you can provide guys. Always appreciate it.