This documentation is archived and is not being maintained.

PivotTable.EnableWizard Property (Excel)

True if the PivotTable Wizard is available. The default value is True. Read/write Boolean.

expression .EnableWizard

expression A variable that represents a PivotTable object.

When this property is set, the field wells aren’t displayed on the worksheet.

This example disables the PivotTable Wizard for the first PivotTable report on worksheet one.

Worksheets(1).PivotTables("Pivot1").EnableWizard = False
Show: