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
    mdorey