Link Error: Source Not Found

[dallin01]

In my current spread sheet -- the Edit Links window says an error: Source not found exists on a non-existent file. It will not let me break the link nor delete it. What can I do to get rid of the error? everytime I open the file the error message box appears. Thanks.

<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="WIDTH: 382.5pt; HEIGHT: 201.75pt" id=Picture_x0020_1 type="#_x0000_t75" alt="" o:spid="_x0000_i1025"><v:imagedata o:href="cid:image001.png@01CB2F1B.DA4DB7E0" src="file:///C:\DOCUME~1\02858\LOCALS~1\Temp\msohtmlclip1\01\clip_image001.png"></v:imagedata></v:shape>

 

[daverunt]

http://www.mrexcel.com/archive/Links/12004.html

 

[dallin01]

Thanks, I'm still not being successful. I'm using Excel 2007 -- the addin is only for 97 & 2000 versions of Excel. I tried searching for a delete link wizard addin for the 2007 excel version and couldn't find it. Is one available for 2007 excel version?

 

[daverunt]

Ok couple more things you can look into.

http://support.microsoft.com/kb/925893

http://en.allexperts.com/q/Excel-1059/Removing-links-workbook.htm

This link explains how to find references to Excel documents at the cell level.

This is a link to a macro you could use for the above if a lot of cells are involved.

http://vbadud.blogspot.com/2006/12/removing-external-links-in-microsoft.html

 

[dallin01]

Thanks, these were most helpful.