Editing Excel LInked File in PowerPoint

		Microsoft Office Forums > Microsoft Office > PowerPoint
Editing Excel LInked File in PowerPoint

FAQ

Thread Tools

Display Modes

05-24-2025, 04:53 AM

macropod

Windows 10 Editing Excel LInked File in PowerPoint

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,366

The simplest approach is to rename File B as File A.

Or you could use a macro like:

Code:

Sub ChangeLinks()
Dim Sld As Slide, Shp As Shape
For Each Sld In ActivePresentation.Slides
  For Each Shp In Sld.Shapes
    With Shp
      If .Type = 10 Then
        With .LinkFormat
          .SourceFullName = Replace(.SourceFullName, "File A.xlsx", "File B.xlsx")
          .Update
        End With
      End If
    End With
  Next
Next
End Sub

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to quikly unlink PowerPoint tables which are linked from Excel?	soroush.kalantari	PowerPoint	2	01-21-2022 08:44 PM
Pasting linked data from excel into PowerPoint	dcmontva	PowerPoint	0	06-25-2019 02:11 AM
Editing PDF files from powerpoint; does not sync with the original PDF file	si14	PowerPoint	1	08-01-2016 07:29 AM
Is it possible to for a flash SWF in powerpoint to run linked to a XML file?	mjw2012	PowerPoint	0	07-20-2012 08:28 AM
Faulty alignment of charts linked from excel to powerpoint	Reem	PowerPoint	0	05-25-2012 05:24 AM