Convert linked charts to embedded

[jmenche]

Howdy,

Our lovely intern copied a bunch of excel charts into Powerpoint 2010 as linked and not embedded objects. Is there a macro to run that would convert these to embedded so we can send it to a client?



Jeff

[macropod]

Try:
[VBA]Sub BreakLinks()
Dim Sld As Slide, Shp As Shape
On Error Resume Next
For Each Sld In ActivePresentation.Slides
For Each Shp In Sld.Shapes
Shp.LinkFormat.BreakLink
Next
Next
End Sub[/VBA]

[John Wilson]

The macro will do the job (breaking any other links though) but you do not need a macro to do this.

File > INFO in the right pane near the bottom "edit links to files"

Select the ones to break (ctrl click of shift click) and hit break links.