Help - Need to be able to update links to a graph in Powerpoint

[Sandra]

Hello,

I am using powerpoint 2003 & Excel 2003.

I have presentation that is linked to a graph in an excel file on a shared
network drive.

The Powerpoint presentation is just 1 page and needs to stay in presentation
mode for 2 hours.

At the same time, the excel spreadsheet will be updated on another computer,
the excel graph will change and the file will be saved.

Without leaving the presentation mode, how can I get the linked graph in
powerpoint to update? (note, I would be able to click on an object in
presentation mode ... if that helps)

This will be nationally televised (in the background) of Santa related
activity - please help

Happy Holidays,

 

[Bill Dilworth]

If you already have the chart on a slide and it is linked to the excel
chart, then you can simply force a repeating update every few seconds by
using a macro. Just link the macro (given below) to run when the chart is
clicked (select chart => Right click => Action setting => On mouse click =>
Run Macro => YouSleighMe). Now, when you click on the chart, the macro
starts, causing a refreshing of the chart every 5 seconds until the slide is
changed or the show is ended.

====Start Code=======
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=======

Of course, you may need to change the slide number, if you have more than
one slide.
Of course, you may also need to change the shape number, if you have more
than one shape.


--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
yahoo2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
..

 

[Kurt]

Sandra,
You could also use datapoint from www.presentationpoint.com to automate
dynamic live presentations

Kurt