Restrict the use of a PivotTable list in the browser
When you change a setting to prevent a user from doing a specific task, you will not be able to do that task in the design program unless you change the setting again.
-
In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
-
Click Commands and Options on the toolbar.
-
Click the title bar of the PivotTable list.
-
In the Commands and Options dialog box, click the Protection tab.
-
Do one of the following:
Prevent adding, changing, or removing filters
-
Clear the Filter check box.
Prevent grouping or changing the layout
-
Clear the Group and change layout check box.
Prevent sorting data in custom order
-
Clear the Custom order items check box.
Prevent displaying detail data
-
Clear the Display detail data check box.
-
Clear the Edit detail data check box.
-
Clear the Insert new detail rows check box.
-
Clear the Delete detail rows check box.
Prevent access to the Commands and Options dialog box
-
Clear the View the Commands and Options Window in run mode check box.
-
Notes
- Even if you clear the View the Commands and Options Window in run mode check box, the Commands and Options button is always available on the toolbar when you are designing the PivotTable list.
- In Microsoft Excel, these restrictions have no effect. Users who export a PivotTable list to Excel from the browser can then use Excel features to view all detail data that is available in the source data. To prevent users from accessing the detail data in this way, you can restrict access to the Export to Microsoft Excel command in the browser by turning off the toolbar, restricting access to the Commands and Options dialog box, and writing code to hide the shortcut menus.