Editing Excel LInked File in PowerPoint

mharoonb · #1 05-24-2025, 01:40 AM

You have a Powerpoint that is linked with an excel file lets call it File A, and there are 50 graphs in that file that you have linked in the Powerpoint in 20 different slides.

Now you have updated file called file B, with same graphs but updated numbers and now you want to edit link all the graphs that were linked with File A (all 50 slides) with File B.

How will you do it ?

because doing it link by link is so annoying.
I do have my own way of doing it in a single click that ensures everything edits properly in a click but am i missing something is there a builtin feature that can do it ?

macropod · #2 05-24-2025, 04:53 AM

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

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