Page 370 - Microsoft Office Excel 2003 Programming Inside Out

Part 5: Manipulating Excel Objects
Microsoft Office Excel 2003 Programming Inside Out

2 On the first step of the wizard, choose the location of your data and then select
PivotTable.

3 The second step of the wizard prompts you to select the source data for the PivotTable.
You can either enter a range in the Range box or press the button at the end of the box
to collapse the dialog box, allowing you to select a range in any of the currently open
workbooks. You can press the Browse button if you want to open a new workbook.

4 In the last step of the wizard, you choose the location where the wizard will place the
Chapter 16
PivotTable. You can select a location on the current worksheet, or the wizard will cre­
ate a new worksheet for you. Pressing the Layout button displays a dialog box that
allows you drag and drop the various fields for the PivotTable’s initial configuration.

344