Changing pivot table source file

Hi, I'm relatively new to pivot tables and have become addicted to them! But I can't seem to solve this one.

I changed the name of my entire document last night. After doing so, each time I try to refresh my data I now get a 'cannot open pivot table source file' error. So I changed the source data and it works fine temporarily. But when I save & close the file then reopen it, the changes have been lost and it's still looking for the previously named source file.

I have at least 15 pivot tables pointing to the same source data, so changing the source file every time I open the document would be a nightmare. Any help you can give me would be appreciated!

Hi, who the version of excel you use?