Mekleg
New member
I link the cells within a master workbook (A) using array formulae to cells within other workbooks (B), (C) & (D), using the data gathered from (B), (C) & (D) to produce reports. When the source workbooks are overwritten with new versions, all the links between the workbooks are broken causing a lot of work revisiting them to recreate the array formulae. Is there a way that I can update the links to search for the newer version, and therefore restoring the links automatically?