Hi Craig!
Try the free FindLink Addin obtainable from:
Stephen Bullen Hosted:
Bill Manville:
http://www.bmsltd.co.uk/MVP/Default.htm
Here's the blurbage:
FindLink.zip v8.6 (01 July 2003, 35k, 35043 downloads) - Updated
To look for links from a workbook, open or install the add-in
FINDLINK.XLA, activate the workbook and use Tools / Find Links. It
will ask you for a text string to look for. You can specify the name
of a specific workbook (e.g. "SOURCE.XLS") or just ".XLS" to find
references to any .XLS file. You can even enter "#REF" to find any
names which refer to deleted ranges or a range name to find where that
named range is used. Optionally the utility will list the occurrences,
list and delete (replacing with values where appropriate), or ask you
what to do with each occurrence. Version 8.6 offers a dropdown list
including the link sources and fixes a number of bugs and omissions in
previous versions.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Wednesday 6th August 2003: Bolivia
(Independence Day), Bulgaria (The Transfiguration), Jamaica
(Independence Day), United Arab Emirates (Accession of H.H. Sheikh
Zayed). Observances: Hiroshima Day (08:15 Local Time 6th August 1945),
Hiroshima Peace Ceremony (Shinto), The Transfiguration (Christianity).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
