Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

605 views
Skip to first unread message

@discussions.microsoft.com Brent

unread,
Apr 22, 2010, 10:48:01 PM4/22/10
to
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?

trip_to_tokyo

unread,
Apr 23, 2010, 3:17:01 AM4/23/10
to
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.

Shyam Pillai

unread,
Apr 23, 2010, 10:41:38 AM4/23/10
to
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...@microsoft.com...

avi

unread,
May 19, 2010, 4:05:07 PM5/19/10
to
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

avi

unread,
May 19, 2010, 4:05:41 PM5/19/10
to

Marcelo Moreira

unread,
Aug 26, 2011, 10:38:27 AM8/26/11
to
Hello, Shyam.

Doesn't your UpdateLinks add-in work in PowerPoint 2010 (64 bits) ?
I loaded the add-in but couldn't find the menu interface to make it work.

Thank you.

> On Thursday, April 22, 2010 10:48 PM 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 did not work. Any ideas would be appreciated?


>> On Friday, April 23, 2010 3:17 AM trip_to_tokyo wrote:

>> 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:


>>> On Friday, April 23, 2010 10:41 AM Shyam Pillai wrote:

>>> 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.

ni...@adelaideinterim.com.au

unread,
Oct 8, 2013, 6:29:25 PM10/8/13
to
Hello Shyam

In Powerpoint 2007, how to you access the configuration window for you UpdateLinks Add-in?

Nigel in Adelaide
-----
0 new messages