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