Links to other documents

[Guest]

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?

 

[Guest]

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.

 

[Guest]

If you go into Edit>Links you will find a reference to your older worksheet.
YOu have an option to change the link to point it to a different worksheet
(may be your current active worksheet) Then all the links will simultaneously
change. It will work as long as you have the same sheet names, cell names etc
in the new work sheet, otherwise you might find it returning error
values.Alternatively, if you simply break the link then all the links will be
stored as values and links no longer work.