View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ashleigh Gardner[_2_] Ashleigh Gardner[_2_] is offline
external usenet poster
 
Posts: 5
Default Break Chart Links

I have a template with several embedded linked charts. After updating values
in the linked workbook, I wish to update my charts and then break all links
(so that further changes in the linked workbook are not reflected in the
charts).

I have tried, for example:
ActiveWorkbook.BreakLinks Name:=linkFileName, Type:=xlLinkTypeExcelLinks
This does not seem to have any impact on the chart links.

I have also tried converting each chart series into an array; however, each
formula requires significanly more than 256 characters to accurately generate
the chart.

I have thought about converting each chart into an image after updating, but
I am not sure how to code something like this. Any suggestions or methods of
breaking chart links would be greatly appreciated!