Prevent users from making changes in PivotChart view
- Open a datasheet or form in PivotTable view or PivotChart view.
- On the PivotChart toolbar, click Properties
, and then click the Show/Hide tab. - Under Let users view, clear one or more of the following check boxes:
- Allow pivot grouping
- Allow pivot filtering
- Selection marks
- Properties dialog box
Warning If you clear this check box, you will not be able to view the Properties dialog box again unless you close the PivotChart view without saving changes and then reopen it.