I am using Office 2019, and have my power point file and the excel file in the same folder on C: drive.
The slide show runs in a loop and I would like to get it to auto refresh with every loop. It worked last year, I cannot seem to get to work this year.
Sub Auto_ShowBegin()
ActivePresentation.UpdateLinks
End Sub
Sub OnSlideShowPageChange(ByVal SSW As SlideShowWindow)
' AUTO UPDATE OF OLE LINKS MACRO
If SSW.View.CurrentShowPosition = 2 Then
ActivePresentation.UpdateLinks
End If
End Sub
Mike P
Wisconsin, USA