Why not make the chart a picture?

--
Regards,
Tom Ogilvy


"Shawn" wrote in message
...
Hi

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 use

With ActiveSheet.UsedRange
.Value = .Value
End With

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)?

Thanks

Shawn