Hi all,

I'm developing a pivot chart for a team that is VERY bad at tech...I need to do the following but can't figure out how.
  1. Prevent dragging/deleting/removing alll pivot fields (totals, filters, categories) but still allow setting of filters. (the user just can't drag them off the chart or add new ones)
  2. Prevent all right clicks (i.e. from Totals Fields, data grid, etc)


Anyone have any ideas how to go about this?