Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Creating PivotTables - Pg. 386

Analyzing Data with PivotTables and PivotCharts 386 12. If the Properties dialog box isn't open, click the Properties button on the toolbar. On the Format tab, notice that the form's Default View property is set to PivotTable. If you expect to work with a form in Form view as well as PivotTable view, be sure to set properties for the form and its controls so that the form behaves and appears as you want it to in Form view. Also, as you can with other forms, you can create an event procedure or a macro for a PivotTable form that runs when one of the form's events occurs.