command for breaking link in excel is not seen.
 

i have copied files containing fromulas to another file. while opening the
new file, each time, it is asking whetehr to update the data from parent
file. I wish to break the link in second file, but could not find the command
for that. while opening links, it shows only three commands, which odes not
include command for ' breaking links'.

Hi Suresh,

If the links are no longer required, delete the link formulae or convert
them to values.

You may find Bill Manville's FINDLINK.XLA addin useful This is freely
downloadable at:

http://www.oaltd.co.uk/mvp

---
Regards,
Norman



"suresh" wrote in message
...
i have copied files containing fromulas to another file. while opening the
new file, each time, it is asking whetehr to update the data from parent
file. I wish to break the link in second file, but could not find the
command
for that. while opening links, it shows only three commands, which odes
not
include command for ' breaking links'.