Pivot Table link to external workbook and naming

[markfell]

Hi Guys,Has anyone done / or have an example of a pivot table that is link to an external workbook.Solution Brief:I have master workbook with 12 worksheets Jan - Dec, here there are 4 columns with sales data etc, this is called master.xlsxNow I can create the pivot table and read the data from Master.xlsx into sales.xlxs and the data is fine.Now at the end of the year and I want to rename master.xlxs to master-2015.xlsx and sales-2015.xlxs, how can I easily change the pivottable information, so I dont have to do a "change data source" on all 12 worksheets in sales to point back to master ??