View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jayco Jayco is offline
external usenet poster
 
Posts: 3
Default 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.