greengo204
Technical User
Currently i am trying to protect a sheet containing a pivot table. I do no wish the user to be able to change the structure of the pivot table and/or be able to edit any cells outside of the pivot table. Although the user should be able to use all the filters in the pivot table to select different fields and be able to refresh the pivot table.
-I uderstand when you protect a sheet that you can allow a user to use pivots, but this option allows them to manipulate the structure.
-Ive tried to select a range that user are allowed to edit (range was all the filters), this did not allow user to use the filters.
Ive been searching around the internet and have been unsuccessful so far in finding a solution.
Does anyone know of a workaround for this issue?
Thanks in advance.
-I uderstand when you protect a sheet that you can allow a user to use pivots, but this option allows them to manipulate the structure.
-Ive tried to select a range that user are allowed to edit (range was all the filters), this did not allow user to use the filters.
Ive been searching around the internet and have been unsuccessful so far in finding a solution.
Does anyone know of a workaround for this issue?
Thanks in advance.