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 (ToolsProtectionProtect 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 he

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.

wrote:
HI !

IS THERE A WAY TO COMPLETELY RESTRICT PIVOT TABLE IN EXCEL 2003.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html