Modify the data connection for a PivotTable list

Choose a data source for the PivotTable list.

Use an existing data source control

  1. Click inside the PivotTable list to activate it.

  2. Click the hyperlink that says Click here to connect to data.

  3. On the Data Source tab, select Data source control, and then select the control that you want from the drop-down list.

  4. Under Use data from, click Data member, table, view, or cube name, and then select the element you want from the list.

Change a connection to a data source

  1. Click inside the PivotTable list to activate it.

  2. Click the hyperlink that says Click here to connect to data.

  3. On the Data Source tab, select Connection, and then click Edit.

  4. Select the OLE DB provider you want to use to retrieve the data, and then click Open.

  5. Under Use data from, do one of the following:

  6. Finish the PivotTable list by customizing the layout and using the toolbar. Use the Commands and Options dialog box in the PivotTable to add totals, set properties, and so on, until the control looks and behaves the way you want.

Create a connection to a new data source

  1. Click inside the PivotTable list to activate it.

  2. Click the hyperlink that says Click here to connect to data.

  3. On the Data Source tab, select Connection, and then click Edit.

  4. Click New Source, then click Open, and then choose the type of data source to which you want to connect.

  5. Under Use data from, do one of the following:
  6. Finish the PivotTable list by customizing the layout and using the toolbar. Use the Commands and Options dialog box in the PivotTable list to add totals, set properties, and so on, until the control looks and behaves the way you want.

Note   For more help on how to design and use a PivotTable list, click Help on the PivotTable toolbar. If the toolbar is not visible, in the Commands and Options dialog box, on the Behavior tab, select the Toolbar check box.