Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Break Links But Keep Formulas | Excel Discussion (Misc queries) | |||
Break Links | Excel Discussion (Misc queries) | |||
Break Links not working !!!! HELP !! | Excel Discussion (Misc queries) | |||
break excel links | Excel Programming | |||
break links | Excel Programming |