RESTRICT PIVOT TABLE IN EXCEL 2003

D

Debra Dalgleish

If you don't want users to change the pivot table, copy it, and paste it
as values in a different workbook.

Or, you can use worksheet protection (Tools>Protection>Protect Sheet),
and don't add a check mark to PivotTable Reports.

You can also use programming to disable part of the pivot table, as
described here:

http://www.contextures.com/xlPivot12.html

Worksheet protection can be cracked though, and someone could use
programming to enable the pivot table, so those methods don't guarantee
that the pivot table is completely restricted.
 
Top