This sheet can be copied to existing workbooks to easier manage linked files.
Using a defined name, links, referring to the formula
Linked files will be displayed and accessible for a VBA macro to open them.
In later versions of Excel, it is also possible to select and open all sources at once directly from the dialog Data: Edit Links.
The list of linked files is updated every time the workbook is recalculated.
- Right click the sheets name
- Move or copy…
- Choose the destination file and check [x] Create a copy
The VBA macro needs to be enabled, [Enable content].
The macro in the defined name may also need the file to be trusted or the function may remain blocked.