Excel Guides

How to Point PivotTables to Different Data Sources in Excel

If you have multiple PivotTables in your workbook, each connected to a different data source, and you want to change the data source for all of the PivotTables at the same time, you can do so by editing the connection information for the workbook as a whole. Here's how:

  1. Open the workbook that contains the PivotTables.
  2. On the Data tab, in the Connections group, click Edit Connection. The Workbook Connections dialog box appears.
  3. In the Workbook Connections dialog box, click Change Source. The Change Data Source dialog box appears.
  4. In the File name box, enter the path and file name of the new data source to which you want to connect all of the PivotTables in your workbook. You can also click Browse to locate and select a file.

  5. Note: If you're using an Office Data Connection (.odc) file or an Office Data Connection Library (.odc) file as your data source, you can't change it by using this method. Instead, use one of the following methods:


  6.   ;   ;   ;   ;   ;   ;   ; & nbsp ; & nbsp ; & nbsp ; & nbsp ; & nbsp ; & nbsp ; & nbps , 6) In 7) If 8) Click 9) In 10), 11), 12), 13), 14), 15), 16), 17), 18), 19), 20). 21). 22). 23). 24).

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.