Power point auto updated from excel

JohnWilson · #1 04-13-2018, 08:15 AM

You can try this then. (not certain it will work)

Step 1.

Insert a command button from the developer toolbox on slide 1. (Show the developer tab in File>Options >Customize ribbon if not already done)

In Home > Select > Selection pane set the button to NOT visible. This is needed to make the code run reliably,

Step 2

Alt f11 to open the Code editor and INSERT > Module

Paste in this code

Code:

Sub OnSlideshowPagechange(SW As SlideShowWindow)

Dim osld As Slide
Dim oshp As Shape
Set osld = SW.View.Slide
On Error Resume Next
For Each oshp In osld.Shapes
oshp.LinkFormat.Update
Next oshp
End Sub

Run the show and update the excel file see if it works - should update the nest time the page shows

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
can power point LINK to embedded object in power point ?	johnseito	PowerPoint	0	05-24-2014 04:31 AM
[Excel 2007] Building Power Point Slides from data in an Excel Table	bremen22	Excel Programming	1	08-07-2013 11:01 AM
Attach a Excel file with Power point	gmalpani	Office	0	11-27-2011 03:11 AM
Microsoft Power Point 2004 to Office Power Point 2007	chuff	PowerPoint	0	03-20-2011 01:23 PM
Info from excel spreadsheet to Power point	anyquist	Office	0	01-31-2011 12:29 PM