#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Pretty sure you can only do this with code.
Is this something you might tackle? |
#3
|
|||
|
|||
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.
|
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
Thank you very much for your help John, I will give it a try! I really appreciate the assistance!
|
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 |