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" <suresh@discussions.microsoft.com> wrote in message
news:3FDBF656-1BAD-4CD0-96D6-812F4642992F@microsoft.com...
>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'.