change Excel without stopping powerpoint presentation

[methody]

Hi

I use excel to do calculations use paste link to link to powerpoint presentations which are view on a large TV monitor. I have a number of slides which rotate.
At the minute when I make a change in Excel I have to come out of the powerpoint, make the change in Excel then restart the powerpoint.

is there any way I can make the change in Excel and have the powerpoint update with having to stop the powerpoint.

thanks

 

[Worf]

Hi

We can automatically update links with VBA. Is a code solution suitable for you?

 

[methody]

Yes that would be good thank you

 

[Worf]

• In PowerPoint, press Alt + F11 to go to the VBE.
• Choose Insert>Module and after that, Insert>Class Module.
• Paste the code below where indicated.
• Before starting the slide show, manually execute the trap events routine.
• That is it. Every time the presentation cycles back to the first slide, links will update.
• If this is too frequent, we can update based on time.

' PowerPoint standard module
Dim cPPTObject As New EventClass, TrapFlag As Boolean
Sub TrapEvents()
If TrapFlag = True Then
    MsgBox "the EventHandler is already active.", _
    vbInformation + vbOKOnly, "PP Event Handler"
    Exit Sub
End If
Set cPPTObject.PPTEvent = Application
TrapFlag = True
End Sub

Sub ReleaseTrap()
If TrapFlag = True Then
    Set cPPTObject.PPTEvent = Nothing
    Set cPPTObject = Nothing
    TrapFlag = False
End If
End Sub

'PowerPoint class module named EventClass

Public WithEvents PPTEvent As Application
Private Sub PPTEvent_SlideShowNextSlide(ByVal Wn As SlideShowWindow)
If Wn.Presentation.SlideShowWindow.View.Slide.SlideIndex = 1 Then
    Dim sl As Slide, sh As Shape
    For Each sl In Wn.Presentation.Slides
        For Each sh In sl.Shapes
            If sh.Type = msoLinkedOLEObject Then sh.LinkFormat.Update
    Next sh, sl
    DoEvents
End If
End Sub

 

[methody]

Hi
Thank you
This is undoubtedly a help.
But my problem how to I make changes in Excel without coming out of the powerpoint. I want the screen to continually show the powerpoint but when I make the changes in Excel is there any way that I can do it without it being visible on screen.
May it is not possible but I wondered if there was some display setting that might work

 

[Worf]

https://support.office.com/en-us/ar...orksheet-29485589-816e-4841-81b7-ff90ae5a2cc4

On a single monitor computer, obviously it is not possible to change the worksheet without leaving the presentation screen.
However,on a dual monitor setup or a network, the slide show will run continuously,with the update code being fired every time the presentation reaches the first slide. The Excel file can be changed while the show runs and nobody will notice.
If you have many linked data, the update may take a few moments, we could use a buffer slide to accommodate that.
The links dialog box has an automatic update option, but I have not tested it yet, see the page above.
Post back if you still have doubts.