Pivots linked to original workbook

Hi,

I have a workbook with a bunch of pivot tables that are linked to tables contained within the workbook.

When I make a copy of the workbook and paste it with a new name in a different folder, I find that the pivot tables in the new workbook are sourced back to the the tables in the original workbook location (z:/.../.../tablename).

This is the only workbook that I have issues like this. I use pivot tables all the time in other workbooks without this issue. Have I changed a setting somewhere?

I should say that if I edit all the pivots to point to the current workbook table name, then re-save the file as a new name, the problem returns.