Under the DATA Ribbon, look for the Edit Links. That will identify the files used in formulas. The file path may be obscured if it is long.
If you have access to the INQUIRE add-in, you can run a Workbook Analysis to identify cells using external links and the formula with the external link.
|