RESTRICT PIVOT TABLE IN EXCEL 2003
 

HI !

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

RESTRICT PIVOT TABLE IN EXCEL 2003
 

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