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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|