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:
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
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?