Re: Change Pivot Table Source File
This is maybe the answer. It coming lately, but this bug also appears in Excel 2010 and I experienced it.
Note : I translate french excel terms and it may not be exactly the same as in your english excel version.
1) Open both files in your excel (old source and the new file)
2) Go to "Options" and then "Change data source"
3) Minimize the window (here is the trick!!!) and choose the new data source (whitout minimizing, you can't choose the source or even you can't paste the new source)