[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