They aren't necessarily hyperlinks. If you refer to a cell in a particular
sheet in another workbook or even the same workbook, and you delete
that sheet the link to that cell is broken and you would see #REF! that
has nothing to do with a hyperlink -- although you could have cells with
invalid references that are also hyperlinks.

To help you find the problems download findlink by Bill Manville in
http://www.oaltd.co.uk/MVP/Default.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"smart.daisy" wrote in message ...
I have a big file with several worksheets. All worksheets used formula
linking to other files. When I hit update link, it tells me that some links
are unvalid. How can I check which link is actually unvalid? I use excel2000.
Thanks.