none
Disconnect Charts data in powerpoint RRS feed

  • Question

  • Hi,

    I have the following code which updated charts links to Excel workbook

    pptWorkbook.ChangeLink Name:="MasterData.xlsx", NewName:=NewName
    Set pptChart = Shp.Chart
    Set pptChartData = pptChart.ChartData
    pptChartData.Activate
    Set pptWorkbook = pptChartData.Workbook

    On Error Resume Next
    pptWorkbook.UpdateLink pptWorkbook.linksources(1)
    On Error GoTo 0

    What I would like to do is disconnect each chart from the liked workbook what is the correct syntax

    ???pptWorkbook.BreakLink pptWorkbook.linksources(1)??? (does not work)


    Guy Zommer

    Tuesday, July 26, 2016 8:56 AM

All replies

  • Hi, does anybody has an idea I tried

    pptWorkbook.BreakLink (workbook name) does not work


    Guy Zommer

    Wednesday, July 27, 2016 9:29 AM