View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gary_wyman gary_wyman is offline
external usenet poster
 
Posts: 7
Default Restricting Data Elements in Pivot Table

Is there a way to restrict the user of a Pivot Table from changing the Data
elements while still allowing them to change the value of a Page element?
When I protect the worksheet, the Pivot Table becomes completely locked.