In some workbooks, you might want to allow users to make changes to a pivot table, but you need to protect formulas or data in other areas of the worksheet. If you protect the worksheet and enable pivot table use, users will be able to modify the pivot table, but won’t have access to other [...]

In some workbooks, you might want to prevent users from making any changes to a pivot table. You want them to see the pivot table, but not change it. However, users might need to make changes to data in other areas of the worksheet. If you protect the worksheet without enabling pivot table use, users [...]