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:

• "Change a data source for an Office Data Connection (.odc) file" section later in this article., or
• "Change a data source for an Office Data Connection Library (.odc) file" section later in this article..

        ;

  ;   ;   ;   ;   ;   ;   ; & 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).