If I save the xls with a new name, pivot tables sources are linked to the original file

Hi experts!

This is driving me crazy and it seems that some people have had the same issue but there is documented solution as far I could see in Google and forums.

Basically If I go to "Save as..." and build a new file version, the sources of pivot tables link to the first file. They don't change dinamically as they are supposed to do. Do you know what could be happening?

Thanks for your help
Geronimo

Here it is the solution:

I didn't seen any real resolution that was simple on this thread so I'm posting. This method seemed to work for me.

In Windows Explorer, right-click on the file and select copy. Then Paste into the same folder. A new file will be created as 'filename COPY'. You can then just re-edit the filename as desired there (ie. with a new date). You can then update whatever data tables you have and the pivot tables will be referencing those tables internal to that document and not the old file.

Thank goodness that worked!

Hope it helps anyone else out there!

Phil

Source: https://social.technet.microsoft.com...&prof=required