Hi,
trying to set up a pivot table which can be modified only by slicers
but if select the checkbox of "use pivot table reports" when protecting the sheet, the user can modify which fields are displayed on the pivot table
if I do not select the checkbox, then when using the slicer, error occurs.
any workaround out-there?
any tips welcome
thank you!!
Bookmarks