On opening a spreadsheet I get the message propmting me to find a linke
cell on another file (now deleted).

The problem is I cannot find the relevant cell in the parent workboo
which specifies the link cell

Is there any VBA code or otherwise where I can search for the cel
containing the link reference ?

I have tried going through every sheet looking for the file name i
each cell using the search option - but no joy

--
Message posted from http://www.ExcelForum.com

Hi
you may have a look at the following site:
http://www.bmsltd.ie/MVP/Default.htm
Search for Bill Manvilles Findlink tool.
Note: The site is currently not fully operating as Stephen is working
on his site.

--
Regards
Frank Kabel
Frankfurt, Germany

On opening a spreadsheet I get the message propmting me to find a
linked cell on another file (now deleted).

The problem is I cannot find the relevant cell in the parent workbook
which specifies the link cell

Is there any VBA code or otherwise where I can search for the cell
containing the link reference ?

I have tried going through every sheet looking for the file name in
each cell using the search option - but no joy.


---
Message posted from http://www.ExcelForum.com/