LinkSources without opening the file

%3CLINGO-SUB%20id%3D%22lingo-sub-2140271%22%20slang%3D%22en-US%22%3ELinkSources%20without%20opening%20the%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2140271%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20need%20some%20help%20regarding%20the%20following%20issue.%3CBR%20%2F%3EWhen%20you%20want%20to%20change%20an%20Excel%20file%20it's%20worth%20knowing%20if%20there%20is%20any%20other%20file%20that%20has%20any%20link%20to%20it.%20(Otherwise%20any%20change%20may%20disrupt%20someone's%20work%20in%20the%20company.)%3CBR%20%2F%3EI%20know%20how%20to%20get%20the%20links%20of%20any%20file%20(LinkSources)%2C%20but%20I%20don't%20want%20to%20open%20thousands%20of%20files.%20That%20would%20take%20days.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20way%20to%20get%20the%20LinkSource%20info%20of%20any%20file%20without%20opening%20it%3F%3CBR%20%2F%3EWhere%20is%20LinkSource%20info%20stored%20in%20the%20file%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance%2C%3CBR%20%2F%3EScipio%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2140271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
Hi,

I need some help regarding the following issue.
When you want to change an Excel file it's worth knowing if there is any other file that has any link to it. (Otherwise any change may disrupt someone's work in the company.)
I know how to get the links of any file (LinkSources), but I don't want to open thousands of files. That would take days.

Is there a way to get the LinkSource info of any file without opening it?
Where is LinkSource info stored in the file?

Thanks in advance,
Scipio
0 Replies