[AccessD] (OT) Disabling Links in Excel

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