Hi,

I need to protect one of the filters with password that it wont be able to change the chosing thing in that cell and giv an option to change all the other filters.

in the pivot table in the report filters area i have 2 filters and i want to be able to protect one and keep it as it is and not to be able to change the filter, and for the other filter keep it open and changeable.

hope i was clear enough and you will be able to help me.

Thanks,
Guy