Show All

Select different source data for a PivotTable or PivotChart report

If you returned data from an Office Data Connection file (.odc extension) directly to a PivotTable report, or your report is based on OLAP source data, you cannot use different source data in the report.

1. Click the PivotTable report. For a PivotChart report, click the associated PivotTable report.
2. On the Data menu, click PivotTable and PivotChart Report
3. In step 3 of the wizard, click Back.

   If the Back button is unavailable, your report is based on OLAP data, and you cannot change it to use different source data. If you want a report based on a different OLAP cube, create a new report.

4. In step 2 of the wizard, notice whether the report is based on an Microsoft Excel range (the step has an edit box labeled Range:) or external data (the step has a Get Data button), and then do one of the following:

   Specify a different Excel range

   1. If the data you want is on a different worksheet, click the worksheet.
   2. Select the new source data range.

   Specify different external data

   1. Click Get Data.
   2. In Microsoft Query, make changes to the query. For help with the specifics of changing the query, see Help in Microsoft Query.
   3. On the Query File menu, click Return data to Microsoft Excel.
5. Click Finish.

6. Drag any new fields that you want to display from the PivotTable Field List window onto the report.

Note  After you make this change to a PivotChart report or its associated PivotTable report, some chart formatting may be lost.