PowerPoint cannot update a leaderboard live. Nothing you find in the next twenty minutes will change that, so it's worth saying in the first line rather than the last. If live is what you actually need, stop here and read the Google Sheets guide instead, which does it properly and for nothing.
What it can do is three things, and one of them is probably better than what you came here for.
You can link a slide to a spreadsheet, so it updates when you refresh it. You can update slides by hand between rounds, which is less mad than it sounds. Or you can stop trying to make it live and build a reveal instead, which for most events is the stronger choice.
Why People End Up Here.
Almost nobody wants PowerPoint specifically. They want the standings to look like they belong at the event.
The scoring already works. It's in a spreadsheet, the numbers are right, and putting that spreadsheet on the ballroom screen looks like exactly what it is. Meanwhile the run sheet, the client's logo, the fonts and the whole look of the day already live in a deck.
So the instinct is correct. The client screen is not a reporting problem, it's a production one. PowerPoint is just the wrong tool for the live half of it.
Option 1. Link A Slide To Your Spreadsheet.
In Excel, copy the leaderboard range. In PowerPoint, Home, Paste, Paste Special, and choose Paste Link as a Microsoft Excel Worksheet Object.
The slide now shows live cells. Change the spreadsheet, right-click the object on the slide and choose Update Link, and the numbers move.
Worth knowing before you rely on it:
- It updates when you tell it to, or when you reopen the file. Not on its own, and never while you are presenting.
- The link is a file path. Move either file, rename a folder, or send the deck to your AV supplier, and it breaks.
- Formatting is inherited from Excel and fights you. Expect to spend longer than you think.
It works. It is fragile, and event day is where fragile things go to be discovered.
Option 2. Update It By Hand Between Rounds.
Genuinely viable, and dismissed too quickly.
A six-game event has five moments where the standings change and anyone cares. That is five slide edits across a whole day. One person, ninety seconds each, done between rounds while a facilitator is briefing the next station.
Build one results slide, duplicate it per round, and type the numbers in. Everything is under your control, nothing is linked, nothing breaks when the file moves, and it looks exactly the way you designed it.
The catch is the same as every manual step. Somebody has to type the right number onto the right slide at the right time, and that somebody is already doing three other things.
Option 3. Stop Making It Live. Build A Reveal.
This is the one worth considering properly.
A leaderboard that updates constantly is not automatically good theatre. Standings that tick over quietly in the corner all afternoon give the room nothing to react to. Once teams stop looking, a live board is just a screensaver with numbers on it.
A reveal is different. You hold the standings, you bring them up between rounds, and the room watches it happen.
In PowerPoint that is easy, because it is what PowerPoint is for.
- Build the table with positions blank, then animate them in from fifth to first.
- Give first place its own build. A wipe, a scale, a colour change, anything that lands.
- Keep it to five rows. Nobody at the back is reading twelve.
- Hold on the top two before revealing the leader. The pause is the effect.
You lose live updating. You gain a moment in the run sheet, and a client who remembers it.
For a lot of events, a well-built reveal between rounds beats a live board, and it costs nothing.
Make It Readable From The Back.
Whatever you choose, the same three rules:
Size for the back of the room, not for your laptop. Team names 40pt minimum on a 16:9 slide, scores larger. If you can read it comfortably at arm's length on a 13-inch screen, it is too small for a ballroom.
Five rows, not twelve. The teams who care about eleventh place are already checking with a facilitator.
Use the client's colours, not yours. They picked them, they have a brand book, and this is the one slide everyone in the room looks at.
Where This Runs Out.
It is not live and it cannot be. Every route above is either manual or a refresh you trigger. If you need standings that move as the score lands, PowerPoint is the wrong tool and no amount of setup changes that.
It is another thing to keep in sync. Now the truth lives in a spreadsheet and a copy of it lives in a deck. Two places for a number to be wrong instead of one.
It needs a person. Whoever is running the deck is now also the scoring department. On a busy day that person does not exist.
A cut game breaks the deck too. The client drops a game at 11am because the morning overran. Your spreadsheet needs rebuilding and so does every results slide after that point.
So What Should You Actually Do?
Score in Google Sheets. Reveal in PowerPoint.
That combination costs nothing and it plays to what each one is good at. Sheets handles the scoring, including several people entering at once and a version history when a number is questioned. PowerPoint handles the moment, on your slide, in the client's colours, with the reveal built the way you want it.
Manually retyping five numbers between rounds is not beneath you. It is a perfectly sensible way to run an event, and we did it for years.
The reason we stopped was volume. At 200 to 300 events a year, sometimes ten in a week, "one person retypes the numbers between rounds" is a role. And the deck and the sheet disagreeing at least once is not a possibility, it is a scheduled event.
GamesTally Score puts the standings on the client screen in the client's branding, updating as results land, with a reveal you control when you want the room to watch. One source of truth, no deck to keep in sync, and everyone in the room can follow it on their own phone if you want them to. USD 4,000, once.
For a handful of events a year, though, build the reveal. It works, and it looks better than most live boards.
Related: Live leaderboard in Excel, with a free template · Live leaderboard in Google Sheets · How to run a lucky draw in Excel