<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] (OT) Disabling Links in Excel</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Did you try the delink tool? This is the only way to find some links. If the link is in the spreadsheet you can also go <tools><options<formulas> and visibly scan the spreadsheet. This will not necessarily find all links, however whereas the tool will.</FONT></P>
<P><FONT SIZE=2>Jim</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Oleg_123@xuppa.com [<A HREF="mailto:Oleg_123@xuppa.com">mailto:Oleg_123@xuppa.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Friday, May 09, 2003 2:09 PM</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] (OT) Disabling Links in Excel</FONT>
</P>
<BR>
<P><FONT SIZE=2>nop, doesn't work I've deleted all the named ranges but one link is still</FONT>
<BR><FONT SIZE=2>left that I can't seem to get rid off</FONT>
</P>
<P><FONT SIZE=2>> Hi, Oleg</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Check to see if your spreadsheet has any named ranges that have</FONT>
<BR><FONT SIZE=2>> references to out-of-book sources. Since you're severing the ties to</FONT>
<BR><FONT SIZE=2>> external sources, you should be able to safely delete such named ranges</FONT>
<BR><FONT SIZE=2>> AFTER doing the Copy/Paste Special/Values routine.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Hope this helps.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Don McGillivray</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> -----Original Message-----</FONT>
<BR><FONT SIZE=2>> From: Gustav Brock [<A HREF="mailto:gustav@cactus.dk">mailto:gustav@cactus.dk</A>]</FONT>
<BR><FONT SIZE=2>> Sent: Friday, May 09, 2003 2:10 AM</FONT>
<BR><FONT SIZE=2>> To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> Subject: Re: [AccessD] (OT) Disabling Links in Excel</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Hi Oleg</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Yes, I think that is what I thought of - however I'm not an Excel guru</FONT>
<BR><FONT SIZE=2>> and others may have better advice for you.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> /gustav</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>> you mean cop/paste special-values ?</FONT>
<BR><FONT SIZE=2>>> I've done that; it get read of 4 links, but still keeps one. And there</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>> is still that "Would you like to refresh the lnik" message which</FONT>
<BR><FONT SIZE=2>>> management doesn't like.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>>> Hi Oleg</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>> If you use the workbook just for sending data with no need for</FONT>
<BR><FONT SIZE=2>>>> formulas you can replace all formulas and links of the cells with the</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>>> calculated values.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> AccessD mailing list</FONT>
<BR><FONT SIZE=2>> AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> <A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>> Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> AccessD mailing list</FONT>
<BR><FONT SIZE=2>> AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> <A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>> Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-----------------------------------------</FONT>
<BR><FONT SIZE=2>You are entitled to Get 100% FREE perfume (S&H is FREE)!</FONT>
<BR><FONT SIZE=2>Click Here: <A HREF="http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail" TARGET="_blank">http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail</A></FONT>
</P>
<BR>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>