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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!