Copy and paste link as value and the rest of the formula as formula

[dida]

Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
In many case that I have to report data by several format, I create the format in specific excel file and link the number to another sheet in this excel, then I want to copy it to another file, when pasting I want the formulas that is sums/+/- will preserve and the formula that is link to the others sheets file will not be. Does anyone have an idea how can I do it?<o></o>
As for today I am copying the sheet to new workbook, then I break the link, that's way the cell that are link become value and the formula that is sums/-/+ is preserve and that's exactly what I need it is just a long way, is there possible VBA code that can make it simplify??<o></o>
Thanks!<o></o>

 

[SydneyGeek]

This will break the links to Book1:

    ActiveWorkbook.BreakLink Name:="Book1", Type:=xlExcelLinks

Denis