Hello,
I am working on an excel file that will be sent out to multiple stakeholders. It contains a pivot table with sensitive data. I do not want department heads to be able to go into the pivot table and use the dropdown on one of the filters at the top of the pivot to look at other departments' data. In other words, I want to lock/disable one of the filters at the top of the pivot table so it is not accessible. Is it possible to lock/disable one filter at the top of the pivot table?
Any help appreciated
Reply With Quote