Category Archives: Protection

Protect Pivot Table Source Data

If you have a pivot table that contains sales data for several regions, can you send each manager a copy of the pivot table with their region selected in the Report Filter, and prevent them from seeing data for other … Continue reading

Posted in Protection | 2 Comments

Allow Excel Pivot Table Use on Protected Sheet

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, … Continue reading

Posted in Protection | 7 Comments

Block Excel Pivot Table on Protected Sheet

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 … Continue reading

Posted in Protection | Leave a comment