How do I force PP to update from excel?

[Guest]

I have made an excel sheet using several live updates from web-sites. The
data are collected from exchange rates, stock prices, commodity prices and so
on every 5 minutes. I have linked this excel-sheet into a powerpoint
presentation. The powerpoint presentation is in a neverending loop. This
works nicely and powerpoint get the updated figures from the web at startup.

How can I force powerpoint to refresh the content from excel so the numbers
are updated continuously (every 5 minutes or every time the presentation
starts over)??

 

[Tushar Mehta]

You will have to do it programmatically. For examples see
http://groups.google.com/group/microsoft.public.powerpoint/msg/d576d044f5fe2
ea8
or
http://groups.google.com/group/microsoft.public.powerpoint/msg/d1db214af1e86
7c5
To incorporate a timing loop into the code, you will have to use the Windows
API's SetTimer and KillTimer. Examples are (or at least were) available on
Shyam Pillai's site at www.mvps.org/skp.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions