Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > PowerPoint

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-08-2019, 01:13 PM
WINTERSOLDIER12 WINTERSOLDIER12 is offline Windows 10 Office 2013
Novice
 
Join Date: May 2019
Posts: 3
WINTERSOLDIER12 is on a distinguished road
Default Presentation Mode Updates

I have a linked excel table "object" in a power point presentation. The idea is to be able to put the Powerpoint in presentation mode and when the excel is updated it will update on the big screen above.




This process is not working out as I can update the slide itself but the full screen presentation is not updating as I modify the excel document.


I am not sure if this is a setting that I haven't selected but the intent was a heads up display on the overhead that would allow my team to see data that has been edited on the excel in real time.



I am hoping one of the experts can help
Reply With Quote
  #2  
Old 05-09-2019, 10:20 PM
JohnWilson JohnWilson is offline Windows 10 Office 2016
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,760
JohnWilson will become famous soon enoughJohnWilson will become famous soon enough
Default

Pretty sure you can only do this with code.

Is this something you might tackle?
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 05-10-2019, 05:36 AM
WINTERSOLDIER12 WINTERSOLDIER12 is offline Windows 10 Office 2013
Novice
 
Join Date: May 2019
Posts: 3
WINTERSOLDIER12 is on a distinguished road
Default

I have limited coding experience. I am learning as I go, but I am limited in my coding abilities. (I am whats known as a script kiddie) I know enough to manipulate but creating raw code is not my forte.
Reply With Quote
  #4  
Old 05-10-2019, 08:34 AM
JohnWilson JohnWilson is offline Windows 10 Office 2016
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,760
JohnWilson will become famous soon enoughJohnWilson will become famous soon enough
Default

I'm really not an Excel coder but if you put this in the ThisWorkbook where the linked data is it should update the current PPT (even in show mode). Make sure you change the slide and shape number to match what you have or it will error.

Code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

Dim PPTApp As Object
Dim PPTPres As Object
Set PPTApp = CreateObject(Class:="PowerPoint.Application")
Set PPTPres = PPTApp.ActivePresentation
' Change to match linked shape
PPTPres.Slides(1).Shapes(3).LinkFormat.Update
End Sub
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #5  
Old 05-10-2019, 08:36 AM
WINTERSOLDIER12 WINTERSOLDIER12 is offline Windows 10 Office 2013
Novice
 
Join Date: May 2019
Posts: 3
WINTERSOLDIER12 is on a distinguished road
Default

Thank you very much for your help John, I will give it a try! I really appreciate the assistance!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Box I can edit in Presentation Mode llomax83 PowerPoint 0 10-24-2016 01:24 PM
Use of pointer in presentation mode pedalpower PowerPoint 0 10-23-2014 08:51 AM
Hyperlinks in presentation mode michaelwoosley Visio 0 09-07-2014 10:36 AM
How to move stuff around while in presentation mode? jcodi PowerPoint 1 03-08-2013 01:16 AM
word 2010 presentation mode chaci Word 1 03-26-2012 02:48 PM


All times are GMT -7. The time now is 10:08 PM.


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