PivotTable.EnableWizard Property (Excel)
True if the PivotTable Wizard is available. The default value is True. Read/write Boolean.
Syntax
expression .EnableWizard
expression A variable that represents a PivotTable object.
Remarks
When this property is set, the field wells aren’t displayed on the worksheet.
Example
This example disables the PivotTable Wizard for the first PivotTable report on worksheet one.
Worksheets(1).PivotTables("Pivot1").EnableWizard = False