Pivot Tables: Locking Certain Features

[Jayco]

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]

As responded in microsoft.public.excel:

You can use programming to disable some features, as described here:

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

 

[Jayco]

Thanks Debra. That really helps.

As responded in microsoft.public.excel:

You can use programming to disable some features, as described here:

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