Hi,

I am having the same probem described below; unfortunately, there is no resolution to it.

http://www.mrexcel.com/forum/excel-q...-workbook.html

Whenever I modify the name/location of the file, the pivot linkage remains to the old data source. Here are some screens:

a.PNG

b.PNG

Thanks,

Mike