command for breaking link in excel is not seen.

S

suresh

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

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
 
Top