PC Review


Reply
Thread Tools Rate Thread

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

 
 
Brent
Guest
Posts: n/a
 
      23rd Apr 2010
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?
 
Reply With Quote
 
 
 
 
trip_to_tokyo
Guest
Posts: n/a
 
      23rd Apr 2010
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?

 
Reply With Quote
 
Shyam Pillai
Guest
Posts: n/a
 
      23rd Apr 2010
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
news:68ADBC17-5F36-454C-8FB0-(E-Mail Removed)...
> 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?


 
Reply With Quote
 
avi
Guest
Posts: n/a
 
      19th May 2010
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
 
Reply With Quote
 
avi
Guest
Posts: n/a
 
      19th May 2010
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Auto update of daily web data into excel angelfire20 Microsoft Excel Programming 3 2nd Feb 2010 02:03 PM
Update Excel spreadsheet with Powerpoint Data Wi11y13 Microsoft Excel Misc 1 14th Sep 2009 09:29 PM
How do I do a formula to update numbers daily? =?Utf-8?B?Ym85MjI=?= Microsoft Excel Worksheet Functions 0 8th Mar 2006 08:08 PM
Formula to capture historical data from data that changes daily =?Utf-8?B?REtlbm5lZHk=?= Microsoft Excel Worksheet Functions 0 28th Dec 2005 08:23 PM
Excel - Powerpoint automatic data interchange and update Iker Microsoft Powerpoint 1 30th Apr 2004 04:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:13 AM.