Links to other files

[Officer_Bierschnitt]

Hi,

I know there is a possibility in Excel to display the paths and names of all files which this particular one links to.
My question is, is there any method - easier than typing it off - to get this info onto another sheet?

Background: We have a spiderweb of Excel_files on_site and no one knows what are the "right and left neighbours" of his/her Excel_file, so no one knows what he/she might break by introducing some change in his/her file.



Now, me and a colleague have developed a docu_sheet with a responsible for each list, a list of files that particular one draws from and the files that draw from this.
I now want to have IT make this into a template_file and drop it into the directories of each and every PC and laptop on_site so this sheet will become a part of each new list generated.
But expecting the employees to type the info from this dialog onto that new sheet could well be expected from them, but it is just more than can reasonably be expected to happen ... so I would like to offer some easier and more convenient way of getting that info there.

Thanks a lot!
Best regards,

Officer_Bierschnitt