Hi, could anyone advise how to automatically change the external data source for a pivot table according to the username of the person logged in to Windows?

I need to use two separate excel files: one containing the pivot table and a separate file containing the source data. Both files will exist in the user's My Documents folder. I need to distribute the pivot table file to multiple users. When they open the pivot table file, the data source needs to be their own "...\My Documents\source data.xls" How can this be achieved?

Many thanks in advance,

Jack.