How to set data source for pivot table permenant even if file name or path changed

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

Thank you for the reply, teylyn.
Yes, the data source is in the same file. I think that the problem is linked to the fact that the data source is in table or range format. I also tried removing the table and it seemed to work. the problem is that I need the table formatting, as it helps me process the document easier and faster.
I tried that prior to posting. It works for the moment, but after reopening the document, the result is the same - the old workbook name still appears in the reference.

Thanks,
Mike

Here is the Document: http://we.tl/nFJZXRfZaT
The link will only be available for 7 days.

Yes, it helps for the moment, but as soon as I save it with a different name, the new file is linked to the old source.
Book8_v3.xlsx

I also added a screen with all the steps that I'm performing, in case it is of any help:

1) update the source to the table name (without the worbook name)
2) save as a different version
3) close.
4) When I re-open the workbook, it's linked to the old one.

Thank you for the replies!