H

I'm attempting to copy a worksheet from one workboo to antoher and than have the data as values in the new workbook including charts. I can us

With ActiveSheet.UsedRang
.Value = .Valu
End Wit

to turn all cells into values. The problem is with chart data sources. They stay as links to the source workbook and every time I open the new workbook it asks for link refresh

Is there a way of eliminating this programmatically and keeping chart appearance unchanged at the same time (almost like treating charts as pictures)

Thank

Shawn