Is there an easy way in Excel 2007 to rename the location of pivot tables
(something along the lines of what you can do within edit links).

I have about a dozen files each containing about 10 pivot tables that
reference a data file outside the workbook. When copying the whole folder
structure so that I could use the same spreasheets with different data, the
pivot reference still realtes to the old datafile.

I thought the easiest way might be to open my workbook that has the pivot
tables and at the same time the source datafile workbook and re-name the
latter it to a different location. However that doesn't seem to work.

Any ideas much appreciated.

(I do recall in previous versions of excel, if each pivot table referenced
the same data, there was some way to get to that data and change it where
necessary. With my current problem, all pivots are referencing the same
data, so it would be nice if I could just make the change once)

Thanks
Jesper Audi

I need to change the loca