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
Bookmarks