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 EditLinks 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?

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

wrote:

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 EditLinks 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

I suggest Bill Manvilles FindLinks add-in

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


" wrote:

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 EditLinks 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?

On Jan 31, 9:13 pm, Dave Peterson wrote:
Try Bill Manville's FindLink program:http://www.oaltd.co.uk/MVP/Default.htm

wrote:

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 EditLinks 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?

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