J
Jackie C
I have created a presentation in PP where each slide is a linked object to
different cells in an excel table. I would like to be able to run the
presentation (in slide show view - F5) on one computer (pcA) and make changes
to the excel table on another computer (pcB). I have saved all linked files
to the network.
The presentation on pcA doesn't seem to update even though I'm making
changes on pcB. I have attempted to run the below macros (from another
posting) but it doesn't seem to work. I will not be able to click on the
object while in presentation mode because I will be away from pcA. Any
suggestions?
Macros that I attempted to use:
Option Explicit
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Sub YouSleighMe()
On Error GoTo EscapeClaus
Do While SlideShowWindows(1).View.CurrentShowPosition = 1
Sleep (5000)
DoEvents
ActivePresentation.Slides(1).Shapes(1).LinkFormat.Update
Loop
EscapeClaus:
End Sub
====End Code=======
(Courtesy of Bill Dilworth)
different cells in an excel table. I would like to be able to run the
presentation (in slide show view - F5) on one computer (pcA) and make changes
to the excel table on another computer (pcB). I have saved all linked files
to the network.
The presentation on pcA doesn't seem to update even though I'm making
changes on pcB. I have attempted to run the below macros (from another
posting) but it doesn't seem to work. I will not be able to click on the
object while in presentation mode because I will be away from pcA. Any
suggestions?
Macros that I attempted to use:
Option Explicit
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Sub YouSleighMe()
On Error GoTo EscapeClaus
Do While SlideShowWindows(1).View.CurrentShowPosition = 1
Sleep (5000)
DoEvents
ActivePresentation.Slides(1).Shapes(1).LinkFormat.Update
Loop
EscapeClaus:
End Sub
====End Code=======
(Courtesy of Bill Dilworth)