Copy & Pasting in VBA + break links (See thread: Find part of string and delete)

[thedivvy]

Hi, I am copying data & graph set ups from one Excel workbook to another, the original data being copied is in a workbook generated by a template. The template copy is never saved so consequently I don't want the copied data to think it should link to it for updating.

I have been using

    ActiveWorkbook.BreakLink Name:="C building critical equipment targets v41", Type:=xlExcelLinks

but this causes the formulas to be overwritten with static data.

Is there another way of doing this please?

Thanks