If you have 100 links to the same Excel workbook you would expect to be able to update them all at the same time. But that’s just not how it works unfortunately, you still have to update each link individually. Have no fear – VBA to the rescue. Below you will find VBA code for PowerPoint and for Excel. Re: Excel VBA to open PowerPoint Update Links, Save and Close Powerpoint with a new file As for renaming the PP presentation, do that before even opening the file. Make a copy with the name you want, and work with it.
Active4 years ago
- I'm trying to get some VBA code that will update all the links in my presentation. Essentually, the code that would do the same as me going to Edit-> Links, selecting all the links and clicking 'Update Now'. If anyone knows the Powerpoint VBA code that can do this, would be much appreciated.
- 'Updating all links of OLE objects embedded in PowerPoint 'This macro is intended to Update charts/Ranges that are 'copy-pasted from Excel into PowerPoint using 'Paste Link'.
- How to “Refresh Data” via VBA in Power Point? Ask Question 1. Not sure if the code would be the same running it from PowerPoint. I simply open my Excel Workbook and then have it update the PowerPoint for me. PowerPoint VBA to break links in OLEFormat object.
I have hundreds of PowerPoint presentations that all have linked Word objects in them. How can I auto-update all of the links without opening each presentation? I'm assuming it'll be done with VBA, but the only VBA examples I can find are for auto-updating linked Excel objects. I'm not familiar enough with VBA to modify the code.
Ultimately, I'd like to run this via Command Prompt.
Using PowerPoint & Word 2013.
Deduplicator37.3k66 gold badges5252 silver badges9191 bronze badges
Powerpoint Macro To Update Links
derek_derek_
1 Answer
Powerpoint Update All Links
DragonSamu's right ... but to get you started, try this from within PPT itself, then work out how to rewrite it in a scripting language or something that will compile to an EXE
For each file you want to process, open the file (via code) then
Steve RindsbergSteve Rindsberg10.9k11 gold badge1818 silver badges2828 bronze badges
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.