Some pivot table options deal specifically with how a pivot table interacts with external data. Although you've seen the PivotTable Options dialog box before, several options in the lower third of the dialog are specific to external data queries. To display the dialog box shown in Figure 9.18, right-click inside the pivot table and choose Table Options. The options specific to external data are listed here:
Figure 9.18. The options in the lower third of this dialog box are all specific to external data queries. |