Am I making things too complicated?

[KKawahata]

I didn't know if I should place this question in this group or in an
excel group or a MS access group, its a little bit of everything.

Right now I have created a PP presentation with embedded worksheets and
the worksheets are actually just SQL query which draw information from
the MS access database. I'm trying to figure out a way to have the
worksheets update themselves (by that I mean pull the info from the
database) without me having to go open each worksheet individually and
then click "enable automatic refresh" which is what I do currently.

 

[Kurt]

Hi,
You need to have a look at datapoint from www.presentationpoint.com.
With that addon you can build your own live information display that
updates content continuously.

Regards
Kurt

 

[Tushar Mehta]

Others (Shyam Pillai, Steve Rindsberg, and Brian Reilly come to mind)
have shared code similar to that in the links below.

You may want to check
http://groups.google.com/group/microsoft.public.powerpoint/browse_frm/t
hread/266050c1ab82d068/d1db214af1e867c5?
lnk=st&q=update+powerpoint+excel+group%3A*powerpoint*+author%
3Atushar&rnum=9&hl=en#d1db214af1e867c5

and

http://groups.google.com/group/microsoft.public.powerpoint/browse_frm/t
hread/d051479bb2295ce1/d576d044f5fe2ea8?
lnk=st&q=update+powerpoint+excel+group%3A*powerpoint*+author%
3Atushar&rnum=12&hl=en#d576d044f5fe2ea8


--
Regards,

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