Automatically Hide Pivot Table Field List Box
 

After running a pivot table in Excel 2003 the pivot table field list box
automatically appears. Can I change settings so this box does not
automatically appear?

Automatically Hide Pivot Table Field List Box
 

if you are using excel 2000+, put below code in sheet's module .

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Application.ScreenUpdating = False
ActiveWorkbook.ShowPivotTableFieldList = False
Application.ScreenUpdating = True
End Sub


Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)


"RB" wrote:

After running a pivot table in Excel 2003 the pivot table field list box
automatically appears. Can I change settings so this box does not
automatically appear?