Forum Discussion
Powerpoint Macro to remove all linked files
Hi all,
So I have a live PowerPoint file that I save every week in a new file to create a snapshot. The live file is linked to an excel spreadsheet but once I save it, I no longer want it to update. At the minute I am using this macro to break all the links:
Sub BreakAllExcelLinks()
Dim shp As Shape
Dim sld As Slide
'Loop Through Each Slide in ActivePresentation
For Each sld In ActivePresentation.Slides
For Each shp In sld.Shapes
On Error Resume Next
shp.LinkFormat.BreakLink
On Error GoTo 0
Next shp
Next sld
End Sub
This works great however I get this an update message everytime I open the file even though the links have been broken for every single link, so this message needs clearing 18 times. So I'm looking for a macro that either changes the all the 'perceived links' to a manual update so it no longer brings the box up, or a macro that completely removes every link from the linked update box so it shows completely blank and so physically has nothing connected. Is this possible?