A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I get powerpoint to update data daily from excel formula?



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 03:48 AM posted to microsoft.public.powerpoint
Brent
external usenet poster
 
Posts: 8
Default How do I get powerpoint to update data daily from excel formula?

I have a presentation designed for an office lobby and cannot figure out how
to have an excel formula embedded into the slideshow change without shutting
down the presentation and restarting it. The formula displays the number of
days without a safety mishap. I thought by making the powerpoint show a
playlist it might update...it didn't work. Any ideas would be appreciated?
  #2  
Old April 23rd, 2010, 08:17 AM posted to microsoft.public.powerpoint
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default How do I get powerpoint to update data daily from excel formula?

PowerPoint 2007

Brent, for an embedded object you will have to go in and change it manually
to get it to change unless you mean a linked object which operates
differently.

"Brent" wrote:

I have a presentation designed for an office lobby and cannot figure out how
to have an excel formula embedded into the slideshow change without shutting
down the presentation and restarting it. The formula displays the number of
days without a safety mishap. I thought by making the powerpoint show a
playlist it might update...it didn't work. Any ideas would be appreciated?

  #3  
Old April 23rd, 2010, 03:41 PM posted to microsoft.public.powerpoint
Shyam Pillai
external usenet poster
 
Posts: 622
Default How do I get powerpoint to update data daily from excel formula?

You can try my free add-in - Update links -
http://skp.mvps.org/updtlinks.htm. Paste link the desired cells in to the
PowerPoint slide. When you run the slide show with the add-in loaded the
contents will refresh every time it loops. If you intend to edit the Excel
spreadsheet while the slide show is running, ensure that the worksheet is
set to work in shared mode and not exclusive.


--
Regards,
Shyam Pillai
Handout Wizard: http://skp.mvps.org/how. PowerPoint 2010 (32-bit/64-bit)
versions supported.

"Brent" Brent @discussions.microsoft.com wrote in message
...
I have a presentation designed for an office lobby and cannot figure out
how
to have an excel formula embedded into the slideshow change without
shutting
down the presentation and restarting it. The formula displays the number
of
days without a safety mishap. I thought by making the powerpoint show a
playlist it might update...it didn't work. Any ideas would be
appreciated?


  #4  
Old May 19th, 2010, 09:05 PM posted to microsoft.public.powerpoint
avi
external usenet poster
 
Posts: 11
Default How do I get powerpoint to update data daily from excel formula?

Hello,

Please consider using Ezpaste-xl2anywhere for solving all your
automations problem with connecting Excel to PPT or other
applications http://www.ezpaste.net

Regards
Avi
  #5  
Old May 19th, 2010, 09:05 PM posted to microsoft.public.powerpoint
avi
external usenet poster
 
Posts: 11
Default How do I get powerpoint to update data daily from excel formula?

Hello,

Please consider using Ezpaste-xl2anywhere for solving all your
automations problem with connecting Excel to PPT or other
applications http://www.ezpaste.net

Regards
Avi
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.