Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-08-2019, 01:13 PM
WINTERSOLDIER12 WINTERSOLDIER12 is offline Presentation Mode Updates Windows 10 Presentation Mode Updates Office 2013
Novice
Presentation Mode Updates
 
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 Presentation Mode Updates Windows 10 Presentation Mode Updates Office 2016
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

Pretty sure you can only do this with code.

Is this something you might tackle?
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 05-10-2019, 05:36 AM
WINTERSOLDIER12 WINTERSOLDIER12 is offline Presentation Mode Updates Windows 10 Presentation Mode Updates Office 2013
Novice
Presentation Mode Updates
 
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 Presentation Mode Updates Windows 10 Presentation Mode Updates Office 2016
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
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 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #5  
Old 05-10-2019, 08:36 AM
WINTERSOLDIER12 WINTERSOLDIER12 is offline Presentation Mode Updates Windows 10 Presentation Mode Updates Office 2013
Novice
Presentation Mode Updates
 
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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft