View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] JColker@gmail.com is offline
external usenet poster
 
Posts: 1
Default Pivot Table: 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.