About restricting the use of a PivotTable list in the browser

In the browser, users cannot change information about the source database, database fields, and source data.

Only the designer of a PivotTable list can specify what source database to use and what subset of the data to make available as the source data in the PivotTable list.

In the browser, users can display only the data you've made available; if a password is required to access the database, users must enter the password to display the data. Users can refresh the PivotTable list in the browser to reflect any changes in the source data, but they cannot gain more general access to the source database or make any changes to the data it stores.

If their browser fully supports PivotTable lists, users can make many of the same changes to the PivotTable list in the browser that you can make in the design program.

Subject to any restrictions you set when you design the PivotTable list, the user can add or move fields from the field list, change the layout, sort, filter, and group data. Users can analyze the data and create summaries, just as you can in the design program.

To prevent users from making changes to a PivotTable list or accessing portions of the source data that you don't want to make available, you can prevent them from doing the following:

• Accessing the Commands and Options dialog box
• Changing the layout
• Grouping items
• Filtering data
• Sorting data in a custom order
• Viewing detail data
• Adding, editing, or deleting detail data