Excel 2007 - Find formulas that use a named range
 

I have a client who has a large workbook. He converted the file from 2003 to
2007 and now it hangs when he manually calculates one of the sheets. I looked
in the Name Manager and saw that many named ranges had a location in another
file and that in the Value column of that list, it said #REF. I imagine
because that file is not currently open. Is there a way to find all the
formulas that contain a reference to that Named Range?

Additionally, if any of those files have been moved or deleted, would that
cause the calculation to hang but not receive an error message?
--
Judy L