hohoho0214
New Member
- Joined
- Mar 24, 2011
- Messages
- 3
Hi. I need to protect a sheet containing a pivot table. I have already set up a view with all the necessary pivot field lists, and users cannot add/remove field lists. However, they need to be able to use the drop down lists from the already existing fields.
I know this is possible by checking the "Use PivotTable Reports" and deselecting the "Select Locked (Unlocked) Cells". However, they now cannot copy any of the info on the pivot table.
Is there any way to protect this sheet so that users can select cells to copy, use pivot filters, and not be able to change any of the pivot field lists?
I am fine with using either VBA coding or regular excel buttons.
Thanks in advance.
I know this is possible by checking the "Use PivotTable Reports" and deselecting the "Select Locked (Unlocked) Cells". However, they now cannot copy any of the info on the pivot table.
Is there any way to protect this sheet so that users can select cells to copy, use pivot filters, and not be able to change any of the pivot field lists?
I am fine with using either VBA coding or regular excel buttons.
Thanks in advance.