Broken links

Mekleg

New member
Joined
May 12, 2020
Messages
4
Reaction score
0
Points
0
Location
UK
Excel Version(s)
2010, 2016
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?
 
Can't help with the links, never use them, but perhaps you should consider using Power Query to pull the data from workbooks (B), (C) and (D).
 
Back
Top