command for breaking link in excel is not seen.

[Guest]

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

 

[Norman Jones]

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