![]() |
#1
|
|||
|
|||
![]()
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 ? |
#2
|
||||
|
||||
![]()
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] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |