Open Linked Files

This sheet can be copied to existing workbooks to easier manage linked files.

Using a defined name, links, referring to the formula

=IF(RAND()>0;LINKS();LINKS())

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.