How to lock only one page field (report filters) of a pivot table in a protected sheet??? I have a pivot table report with 3 reporting filters.The 1st one is a date, second is a person and the 3rd one is type of a costumer. I have to send that report to every person mentioned in the 2nd report filter(5 people) and none of them should have rights to see the report referring to someone else. My idea is to slash the file to 5 parts according to the second filter(person-5 people in this case) and in each report 2nd reporting filter need to be locked, but the 3rd has to be unlocked so that the pivot table report would be able to refresh and change the data referring to the chosen criterias. Is there anyone who could help me? I am a beginner with macros so that please help....???Many gratitudes to those who will respond! Thanks in advance!