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")