Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > PowerPoint

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-12-2018, 02:07 PM
Coryneph Coryneph is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2018
Posts: 3
Coryneph is on a distinguished road
Default Power point auto updated from excel


I run an event where individuals weigh in one after another and these weights are entered into an excel spread sheet. The spreadsheet calculates the top ten. What I want to do is have a monitor/tv display, using power point,the top 10 throughout the weigh-in? I would like it to update regularly as the top ten changes. Is this possible?

Currently I have the excel spread sheet linked to a power point presentation but have to restart the PowerPoint presentation constantly to update the links. Can this be done another way?
Reply With Quote
  #2  
Old 04-13-2018, 12:53 AM
JohnWilson JohnWilson is offline Windows 7 64bit Office 2016
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,676
JohnWilson will become famous soon enough
Default

Is the PowerPoint Presentation running in show mode?
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 04-13-2018, 07:16 AM
Coryneph Coryneph is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2018
Posts: 3
Coryneph is on a distinguished road
Default

I have the powerpoint presentation running continuously in a loop. I show a couple sponsor pages and the top ten page then repeat continuously. I have to stop the presentation and update all the links because the top ten is changing as people weigh in. I am hoping that as i enter the data in excel and excel updates the top ten it would also update the power point presentation without having to restart powerpoint.

Thanks for your help..
Reply With Quote
  #4  
Old 04-13-2018, 08:15 AM
JohnWilson JohnWilson is offline Windows 7 64bit Office 2016
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,676
JohnWilson will become famous soon enough
Default

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
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #5  
Old 04-13-2018, 11:18 AM
Coryneph Coryneph is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2018
Posts: 3
Coryneph is on a distinguished road
Default

Thanks John Wilson.

I did as you said and it worked perfectly. I will test it a bit but so far so good. No idea what you had me do but you definitely know your stuff.

Thanks again for your help.
Reply With Quote
  #6  
Old 04-24-2018, 02:39 AM
Whooops Whooops is offline Windows 10 Office 2013
Novice
 
Join Date: Jan 2018
Posts: 7
Whooops is on a distinguished road
Default

Just download this Update Links

http://skp.mvps.org/updtlinks.htm
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 06:30 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft