"Jesper Audi" wrote in message
...
Hi Roger

Sorry but I want to avoid having to do that upwards of 10 times in each
workbook.

Do bear in mind that nearly all the pivot tables are the same source and I
would like to change it just once as you would be able to do if I had
hundreds of links referring to an external workbook.

Thanks for your interest

Jesper




"Roger Govier" wrote:

Hi Jesper

Click on any cell within your PTOptions tabData sectionChange Data
Source
--
Regards
Roger Govier

Most (if not all) tasks that can be done manually can be done in a Macro.
Once written and working it will always work and consistently and is ideal
for repetative tasks.

Bill R
Jesper Audi wrote:
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
.