Pivot Tables: Locking Certain Features
 

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.

Pivot Tables: Locking Certain Features
 

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

Pivot Tables: Locking Certain Features
 

Thanks Debra. That really helps.

Debra Dalgleish wrote:
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