Hi

To disable the refreshing of a pivot table, try....
ActiveSheet.PivotTables(1).PivotCache.EnableRefres h = False

To disable the dropdown arrows on a pivot field try....
ActiveSheet.PivotTables(1).PivotFields("XXX").Enab leItemSelection = False


--

Regards

William

XL2003




wrote in message
oups.com...
| 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.
|