Office
Sign in

Change the source data for a PivotTable

  1. Click the PivotTable report.

  2. On the Analyze tab, in the Data group, click Change Data Source, and then click Change Data Source.

    The Change PivotTable Data Source dialog box is displayed.

  3. Do one of the following:

    • To use a different Excel table or cell range, click Select a table or range, and then enter the first cell in the Table/Range text box, and click OK.

      --OR--

    1. To use a different connection, click select a Use an external data source, and then click Choose Connection.

      The Existing Connections dialog box is displayed.

    2. In the Show drop-down list at the top of the dialog box, select the category of connections for which you want to choose a connection or select All Existing Connections (which is the default).

    3. Select a connection from the Select a Connection list box, and then click Open.

      Note: If you choose a connection from the Connections in this Workbook category, you will be reusing or sharing an existing connection. If you choose a connection from the Connection files on the network or Connection files on this computer category, the connection file is copied into the workbook as a new workbook connection, and then used as the new connection for the PivotTable report.

      For more information, see Manage connections to data in a workbook.

    4. Click OK.

  1. Click the PivotTable report.

  2. On the Options tab, in the Data group, click Change Data Source, and then click Change Data Source.

    The Change PivotTable Data source dialog box is displayed.

  3. Do one of the following:

    • To use a different Excel table or cell range, click Select a table or range, and then enter the first cell in the Table/Range text box.

      Alternatively, click Collapse Dialog Button image to temporarily hide the dialog box, select the beginning cell on the worksheet, and then press Expand Dialog Button image .

  4. To use a different connection, click select a Use an external data source, and then click Choose Connection.

    The Existing Connections dialog box is displayed.

  5. In the Show drop-down list at the top of the dialog box, select the category of connections for which you want to choose a connection or select All Existing Connections (which is the default).

  6. Select a connection from the Select a Connection list box, and then click Open.

    Note: If you choose a connection from the Connections in this Workbook category, you will be reusing or sharing an existing connection. If you choose a connection from the Connection files on the network or Connection files on this computer category, the connection file is copied into the workbook as a new workbook connection, and then used as the new connection for the PivotTable report.

    For more information, see Manage connections to data in a workbook.

  7. Click OK.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Create a PivotTable with an external data source

Manage connections to data in a workbook

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×