remove formulas

[frank]

is there a way to remove all links from a work book that
has data from out workbooks. i would like to simply
remove the link but leave the data.

 

[Max]

Try Bill Manville's excellent "FindLink" utility ..
It's available at Stephen Bullen's page:
http://www.oaltd.co.uk/MVP/Default.htm