Change in data source

Here is an easy one for you...I hope!
As many others do, I routinely refresh data in a workbook, do a "save as", rename the file, and the refresh all the pivots it the new data.
However, my pivots are trying to access the old file, and not the current one as desired. I have tried by naming the data (array), and also by simply selecting the data range Neither was successful.

Help! Frustrated with constantly having to change the data source!

G

What is the name (& path) of the old data file vs the new data file?

Perhaps create a dynamic data source? See http://contextures.com/xlPivot01.html#dynamic for details