# PowerPoint links - possible to update when slide show is running?

**URL:** <https://boards.straightdope.com/t/powerpoint-links-possible-to-update-when-slide-show-is-running/244432>\
**Category:** Factual Questions\
**Created:** [May 10, 2004, 10:33am UTC](https://boards.straightdope.com/t/powerpoint-links-possible-to-update-when-slide-show-is-running/244432 "2004-05-10T10:33:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mangetout](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mangetout/32/19_2.png) [@Mangetout](https://boards.straightdope.com/u/Mangetout)\
**Post date:** [May 10, 2004, 10:33am UTC](https://boards.straightdope.com/t/powerpoint-links-possible-to-update-when-slide-show-is-running/244432/1 "2004-05-10T10:33:39Z")

</div>

I’m setting up a video scorecard for a quiz on Friday evening and at the moment, I thought I’d do it like this:

An excel spreadsheet into which the team names and scores per round are entered, various calculations of total and joker rounds are performed, then the results are copied into a different worksheet that is formatted to look nice.  
This is paste linked into a Powerpoint slide.  
The computer has two video cards, so the slide show can be put on the one connected to the video projector, while the other screen allows the spreadsheet to be manipulated.

But the paste link, even when set to auto, only updates when the presentation is in design mode; when the slide show is running, it remains static, showing the information as at when the show was launched.

Does anyone know of a way around this?

---

<div class="post-metadata">

**Author:** ![Mangetout](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mangetout/32/19_2.png) [@Mangetout](https://boards.straightdope.com/u/Mangetout)\
**Post date:** [May 11, 2004, 12:38am UTC](https://boards.straightdope.com/t/powerpoint-links-possible-to-update-when-slide-show-is-running/244432/2 "2004-05-11T00:38:05Z")

</div>

Found it! - [this](http://www.mvps.org/skp/updtlinks.htm) add-in updates links when pages are turned in a looped show.

---

<div class="post-metadata">

**Author:** ![Morbo](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/morbo/32/389_2.png) [@Morbo](https://boards.straightdope.com/u/Morbo)\
**Post date:** [May 11, 2004, 12:44am UTC](https://boards.straightdope.com/t/powerpoint-links-possible-to-update-when-slide-show-is-running/244432/3 "2004-05-11T00:44:01Z")

</div>

It can be done programmatically, although IIRC one of the MVPs wrote an add-in that will do it. I’ll look around for the Add-In, but if I can’t find it I’ll write an add-in that will do it for you and send it to you in mail.

---

<div class="post-metadata">

**Author:** ![Morbo](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/morbo/32/389_2.png) [@Morbo](https://boards.straightdope.com/u/Morbo)\
**Post date:** [May 11, 2004, 12:48am UTC](https://boards.straightdope.com/t/powerpoint-links-possible-to-update-when-slide-show-is-running/244432/4 "2004-05-11T00:48:10Z")

</div>

Note to self: Read beyond the first post before Replying. :smack:

---

<div class="post-metadata">

**Author:** ![Mangetout](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mangetout/32/19_2.png) [@Mangetout](https://boards.straightdope.com/u/Mangetout)\
**Post date:** [May 11, 2004, 10:26am UTC](https://boards.straightdope.com/t/powerpoint-links-possible-to-update-when-slide-show-is-running/244432/5 "2004-05-11T10:26:34Z")

</div>

Your attention is appreciated in any case.