<!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>It is possible for some links to be broken but remain in the spreadsheet. You can use the following tool to locate and break links:</FONT></P>
<P><FONT SIZE=2><A HREF="http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q188/4/49.asp&NoWebContent=1" TARGET="_blank">http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q188/4/49.asp&NoWebContent=1</A></FONT></P>
<P><FONT SIZE=2>HTH</FONT>
<BR><FONT SIZE=2>Jim Hale</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: Thursday, May 08, 2003 10:36 AM</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>Gustav,</FONT>
</P>
<P><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 is</FONT>
<BR><FONT SIZE=2>still that "Would you like to refresh the lnik" message which management</FONT>
<BR><FONT SIZE=2>doesn't like.</FONT>
</P>
<P><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>> calculated values.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> /gustav</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>> I have an excel dovument that is linked to others, that I have to send</FONT>
<BR><FONT SIZE=2>>> to several people each day. When they click for it to open it promts</FONT>
<BR><FONT SIZE=2>>> whether they wish to update the links. I am looking at the document</FONT>
<BR><FONT SIZE=2>>> right now to see how I can disable the links after its finished. The</FONT>
<BR><FONT SIZE=2>>> only options I see are "Update Now", "Open Source", and "Change</FONT>
<BR><FONT SIZE=2>>> Source". Does anyone know how to do it ?</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>> Oleg</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>
</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>