You should be able to do a Find and Replace using
[Book1]Sheet1!
in the find slot (replacing it with the names you use of course), and
nothing in the replace slot.

As always, save your work first.

"Scott" wrote:

I have a giant database and have moved some formulas to a new spreadsheet. I
keep finding refrenses to my old document and want to repair the formulas to
refrence the current document. Is there a way to find all refrences to other
documents using a search? Can I search in the charts for refrences as well?
--
Scott Miller
University of Washington
Chemistry