Updating Excel Links to PowerPoint

[Terry]

Our shop is running Windows 2k and Office 2k. My goal is to have a
PowerPoint slide show looping continuously displaying separate Excel
worksheets. The slide show is then projected onto a wall (a rotating
status board).

I've written some code below so that the linked excel cells get
updated in PowerPoint and this code works if the workbook and
PowerPoint are located on the same computer, however, in my situation,
there are multiple users updating one shared workbook over a network.
The only way I've been able to make the updates work is to manually
stop the slideshow and then restart again. This is not an acceptable
solution. Can someone help me out with some code that would enable
the automatic updates in slideshow view when multiple users are
changing different parts of the linked workbook? Should I use a
different approach?

Sub Macro3()
With ActivePresentation.SlideShowSettings
.ShowType = ppShowTypeSpeaker
.LoopUntilStopped = msoTrue
.RangeType = ppShowAll
.AdvanceMode = ppSlideShowUseSlideTimings
.PointerColor.SchemeColor = ppForeground
.Run
End With
ActivePresentation.UpdateLinks
End Sub

Thanks in advance!

 

[Kurt]

Hi Terry,
I understand your problem. You need to have a fully automated, self-running,
high available solution. Updates on Excel sheets over the network will
probably not work.
www.take-off.as/datapoint is an add-on that enables you to link any
presentation to excel sheets (also over network), databases and text files.
It is used for example as a score board solution where an update on the data
should be displayed immediately.
Have a look at datapoint; you can try it out for free.
Kurt.

 

[Kurt]

Hi Terry,
I understand your problem. You need to have a fully automated, self-running,
high available solution. Updates on Excel sheets over the network will
probably not work.
www.take-off.as/datapoint is an add-on that enables you to link any
presentation to excel sheets (also over network), databases and text files.
It is used for example as a score board solution where an update on the data
should be displayed immediately.
Have a look at datapoint; you can try it out for free.
Kurt.

 

[Guest]

Terry,
Try out the free Update Links add-in available on my site to see if it suits your requirements. It will update the links everytime you loop the show.
http://www.mvps.org/skp/download.htm

Regards
Shyam Pillai

----- Terry wrote: -----

Our shop is running Windows 2k and Office 2k. My goal is to have a
PowerPoint slide show looping continuously displaying separate Excel
worksheets. The slide show is then projected onto a wall (a rotating
status board).

I've written some code below so that the linked excel cells get
updated in PowerPoint and this code works if the workbook and
PowerPoint are located on the same computer, however, in my situation,
there are multiple users updating one shared workbook over a network.
The only way I've been able to make the updates work is to manually
stop the slideshow and then restart again. This is not an acceptable
solution. Can someone help me out with some code that would enable
the automatic updates in slideshow view when multiple users are
changing different parts of the linked workbook? Should I use a
different approach?

Sub Macro3()
With ActivePresentation.SlideShowSettings
.ShowType = ppShowTypeSpeaker
.LoopUntilStopped = msoTrue
.RangeType = ppShowAll
.AdvanceMode = ppSlideShowUseSlideTimings
.PointerColor.SchemeColor = ppForeground
.Run
End With
ActivePresentation.UpdateLinks
End Sub

Thanks in advance!

 

[Terry]

Shyam,

I tried your UpdateLinks addin and for whatever reason it doesn't seem
to work. I put the module in my addins folder and there is an "x"
next to the addin in the Tools menu. I made a link to a spreadsheet
both on my harddrive and on the network and if I make a change to the
spreadsheet values and save the spreadsheet, the changes are not
showing up in the slideshow. Any ideas why it is not working? Am I
suppossed to do anything else to the slideshow to trigger it? I'm
running PP2k on a Win2k laptop. I also tried your LiveWeb addin and
that works perfectly. My security settings are set to low for the
time being.

Thanks!
Terry