Pivotable update file but not the range

  • Hello all,

    Need your help in this one please.

    I have two excel workbooks one with the data and other with the pivotable.

    I would like to have a way to update the file path that will update the pivotable but not the range. (the range is named. "ThisWeek")

    Many thanks