#1
|
|||
|
|||
Have Powerpoint dynamically update from an excel or other file?
Hey everyone
I use powerpoint in my office to play a looping slide show on a large TV for my sales reps. It has charts and shows sales figures and so on. The problem is I have to stop the presentation every morning, remote desktop into the system, edit each slide and re-run the show. Is there any way to have that data in an external file like Excel, that I could save on the server and just update daily with the sales figures? I'm guessing if it's possible, that Powerpoint wouldn't just load new data while the show is in use, but that wouldn't be the end of the world. I could just have a macro coded so when I press a certain keyboard combo, it stops the presentation and refreshes it. The biggest thing is getting those figures somehow. Is there any ideas? |
#2
|
|||
|
|||
Select the data in Excel and copy it. Click on the PowerPoint slide and use the Paste drop-down to choose paste special then click Paste Link. Do the same for charts... copy and Paste special > paste link.
http://office.microsoft.com/en-us/po...101776651.aspx |
#3
|
|||
|
|||
Thanks that works great! Really appreciate it.
For anyone else that finds this, I found this program here http://skp.mvps.org/updtlinks.htm It's a free add in that works in all Powerpoints, it automatically refreshes the data every time the presentation loops which is great. Now I can keep the show looping and update the data at any time! |
#4
|
|||
|
|||
Power Point Automatically Update Chart
Hi
I want to update Chart automatically in PPT Slide Show. My excel file is open in 1 system & PPT slide show open in another System so please tell me how to update PPT slide show when excel file update the data |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to update automatically the “file name” as we do for the “Date”? | Jamal NUMAN | Word | 2 | 01-06-2011 02:43 PM |
Update Document Template when Saving the Document File | bjbercaw | Word | 3 | 11-16-2010 02:03 PM |
Run Excel file with Powerpoint minimized | agios59 | PowerPoint | 1 | 11-16-2010 08:58 AM |
PowerPoint Master - 50 LINKED slides - SLOW Update | salfonsi | PowerPoint | 0 | 09-27-2008 02:55 PM |
PowerPoint can't read x.ppt file? | chronic student | PowerPoint | 0 | 05-30-2006 05:35 AM |