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!
|