Thanks for the response :-)

There is a workbook/timesheet for each adviser that the report looks at and each timesheet has 7 tabs, one for each day of the week (this can be reduced to one, expanded tab, if this would improve speed at all, though the issue does not appear to relate to the links as updating is switched off during the find + replace) - the file path is like Time Sheets\Week 15.13\Manager\Adviser.xls . There are 4 managers, each with approx 12 advisers - all the advisers only have access to Excel 2000 (due to license restrictions), which means the files are larger and more cumbersome than Excel 2007+ xlsx/xlsm and have to be saved in xls only.

It is only this master report that needs to be updated each week (to the new week) and only 7 sheets within it, named Saturday, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday have formulae that need to be altered. As the substructure to each week's folder is the same (manager then adviser.xls) it is only the week portion of the file path that needs changing.

I would usually use an indirect function or similar to find the data, based on the week being displayed in a cell value and use concatenation to build the file path, but this doesn't work in this case, due to the files needing to be open. The "Pull" function, in it's non-volatile form, is also not fit for purpose, so the only solution seems to be this find and replace macro...