Hi RJ,

Try Bill Manville's Findlink Addin available for free download at Chip
Pearson's site:

http://www.cpearson.com/excel/xltools.htm



---
Regards,
Norman



"rjb" wrote in message
...
I have developed a 400-worksheet workbook and during its evolution I have
copied some cells from other worksheets. This has created references to
other
worksheets that no longer exist, so whenever I open the workbook I get the
annoying messages relating to "links not found". I am using Excel 2002.
When
I select Edit/Links then it shows the offending 4 non-existent
spreadsheets
but I cannot locate the cells that reference them. When I use the
Edit/Find
and select Options/Within-Workbook to try to locate the spreadsheet
references to these non-existent spreadsheets, no cell references are
located
by the "Find".
Can anyone suggest how I can locate these "phantom" references and get rid
of them???
--
Thanks, Richard.