As responded in microsoft.public.excel:

You can use programming to disable some features, as described he

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

Jayco wrote:
I'm looking for a way to prevent users from both adjusting pivot
filters or refreshing the pivot. Does anyone know a way to lock these
features, but still alllow users to move/add/remove fields from the
table or select data within the fields?

Help would be greatly appreciated.



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