You can use the excellent utility FINDLINK.XLA, which is freely available
for download from Bill Manville on the following site:-

http://www.bmsltd.ie/mvp/

This will allow you to find all the links and will also allow you to break
them if you wish. One culprit for a link that cannot be found is that you
may well have a named range that is linked to another workbook. If you go
into Insert / Name / Define and then click on each of the names in turn and
look at the reference at the bottom of the dialog box - you may well come
across one that refers to another workbook.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Iain" wrote in message
...
How do you locate the cells which have an external reference? I have
tried
using the links function, but this only shows the files that are
referenced,
not the cells that relate to them.

Thanks,