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.

Visual Basic for Applications
Worksheets(1).PivotTables("Pivot1").EnableWizard = False
enable pivot table wizard enable wizard Enable Wizard Property EnableWizard enablewizard property find out if pivot table wizard is enabled make pivot table wizard available

See also: