Find dependent files linked to an Excel file?

  • Thread starter Thread starter FBJ
  • Start date Start date
F

FBJ

Hi

Anyone got a trick to find if there are any Word or Excel files with
links dependent on a particular Excel file, say "Target.xls"?

I've tried running XP's search for terms in documents - hoping to pick
up the name "Target.xls" in the links of all files, but that doesn't bring
it up. I can't imagine any other way, short of opening every file and
checking the links.

Thanks
FBJ
 
Can you limit your search to a single folder (or a few folders)?

If yes, then this link has a macro that might help you.

http://groups.google.com/[email protected]

You could run it once for each folder to search. Since you could have a
workbook on a CDROM disk (or across multiple shares on a network) with links to
target.xls, it would be pretty difficult to search for all the links.
 
Back
Top