Excel Tip - Finding links to other workbooks
Occasionally a spreadsheet opens and a dialog box informs the user that the ‘workbook contains links to information in another workbook ... Do you wish to update ...’. This can be perplexing if you have no idea which cell in your model is linked. The menu option Edit | Links lists the source of any links, but not the cells making the call. To find it, select one or more worksheets and then choose Edit | Find. In the Find dialog box type .xls and then
.
