I have changed an excel file and deleted a formula containing a link but the
link still remains in the Edit Links option and is also prompted as one of
many links when the file is opened.

How can this be? A search of the entire workbook for the file named in the
link returns data not found. This has happened in several workbooks and one
such link is biarrely to a Visio file.

From previous posings...
Download Bill Manville's FINDLINK addin that will let you do just about
anything you ever wanted with a link. Freely available from:-
http://www.bmsltd.co.uk/MVP/Default.htm

Bill's the best at exactly your type of issue!

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"PX" wrote:

I have changed an excel file and deleted a formula containing a link but the
link still remains in the Edit Links option and is also prompted as one of
many links when the file is opened.

How can this be? A search of the entire workbook for the file named in the
link returns data not found. This has happened in several workbooks and one
such link is biarrely to a Visio file.