Link question

[matts2]

I have a workbook with about 50 sheets that I have put together from
several other workbooks. I have tried to change all the links to the
current workbook, but when I open the wb I get the "update" question.
And when I look at Edit>Links I see a whole bunch of links pointing to
the original workbooks. But I can't find the cells with the links. I
seach the WB for the name in a formula, but Excel claims it is not
there. I have looked myself and I don't find it. I don't want to just
break the link, I want to find the cell and fix it. What else can I do
to find these hidden links?

 

[Dave Peterson]

Try Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

 

[Guest]

I suggest Bill Manvilles FindLinks add-in

http://www.oaltd.co.uk/MVP/Default.htm

 

[matts2]

Try Bill Manville's FindLink program:http://www.oaltd.co.uk/MVP/Default.htm

Thank you to you and JMB. That helped me very much.