I have Workbooks that have more than one pivot table looking at the same external data source. Is there a way to change all pivot table sources at once in a workbook verses changing the data source in each pivot table?

Example: 3 pivot tables looking at external data source with sample.xls extension. If the extension changes to sample.xlsx, the pivot table is not looking at the correct address. Need to change all three pivot tables to be looking for sample.xlsx without opening each pivot table "change data source" to change the .xls to .xlsx.


dcoates