[AccessD] (OT) Disabling Links in Excel

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.
Jim

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
Sent: Friday, May 09, 2003 2:09 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] (OT) Disabling Links in Excel


nop, doesn't work I've deleted all the named ranges but one link is still
left that I can't seem to get rid off

> Hi, Oleg
>
> Check to see if your spreadsheet has any named ranges that have
> references to out-of-book sources.  Since you're severing the ties to
> external sources, you should be able to safely delete such named ranges
> AFTER doing the Copy/Paste Special/Values routine.
>
> Hope this helps.
>
> Don McGillivray
>
> -----Original Message-----
> From: Gustav Brock [mailto:gustav at cactus.dk]
> Sent: Friday, May 09, 2003 2:10 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] (OT) Disabling Links in Excel
>
>
> Hi Oleg
>
> Yes, I think that is what I thought of - however I'm not an Excel guru
> and others may have better advice for you.
>
> /gustav
>
>> you mean cop/paste special-values ?
>> I've done that; it get read of 4 links, but still keeps one. And there
>
>> is still that "Would you like to refresh the lnik" message which
>> management doesn't like.
>
>>> Hi Oleg
>>>
>>> If you use the workbook just for sending data with no need for
>>> formulas you can replace all formulas and links of the cells with the
>
>>> calculated values.
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
You are entitled to Get 100% FREE perfume (S&H is FREE)!
Click Here: http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030509/98c15747/attachment-0001.html>