Here's the deliverable: one title slide with three headline numbers that update the moment the source Excel range changes, refreshed with a right-click instead of a fresh screenshot. No Power BI workspace, no Power Automate flow, no VBA. Just a feature that has existed since Office 95 and that almost nobody remembers is there.
You need two files, both saved somewhere real: an Excel workbook with the numbers you want to show, and a PowerPoint deck with a slide ready for them. That "saved somewhere real" part matters more than it sounds like it should - more on that in a minute. Everything else takes about four minutes.
Why this approach
The obvious alternatives are all worse for this specific job. Re-taking a screenshot every time the numbers change works until someone in the meeting notices last month's revenue is still on the slide. A Power BI tile is the right call for a dashboard forty people check daily, and a wildly overqualified one for a slide you personally open before a single presentation. A Power Automate flow that regenerates the deck on a schedule is the right call if this report goes out to fifty inboxes unattended every Monday, and dead weight if you're the only one who ever opens the file. Paste Link sits in the gap between those: no service, no workspace, no schedule to maintain, just a dialog box you tick once.
Step 1: Build a headline range that already looks like a slide, not a spreadsheet
Before you touch PowerPoint, make the Excel range look like the finished product, because the link will render exactly what the source range looks like, gridlines and all, if you let it.
Set up three cells with live formulas, not typed-in numbers, so the whole thing recalculates the moment new rows land in your data table:
=SUM(SalesData[Revenue])
=B2/MonthlyTarget-1
=SUM(SalesData[NewCustomerFlag])The first pulls total revenue straight from a SalesData table. The second compares it to a named cell called MonthlyTarget. The third sums a helper column that flags a 1 the first time a customer's name appears that month. Put a label underneath each one ("Total Revenue", "vs Target", "New Customers Won") in a smaller, greyed-out font.
Now format the range like it's already on a slide: 54-60pt for the numbers, no cell borders (Home tab > Borders > No Border), gridlines off (View tab > untick Gridlines), and a fill colour that matches your deck's background rather than Excel's default white. Select exactly the cells you want visible, nothing extra - the copied range becomes the fixed boundary of the linked object, so a stray blank column comes along for the ride too.
Step 2: Paste Special, then Paste Link
Save the workbook if you haven't already - Paste Link is unavailable for a workbook that's never touched disk. Then:
- In Excel, select the formatted range and copy it (
Ctrl+C). - Switch to PowerPoint and click the slide.
- On the Home tab, click the small arrow under Paste, then choose Paste Special.
- In the dialog, select Paste link on the left, choose Microsoft Excel Worksheet Object on the right, and click OK.
Resize gently if you need to - drag a corner handle rather than an edge, and don't stretch it much. If it needs to be bigger, go back and increase the font size at the source instead of scaling the object; a linked OLE object that's been dragged to twice its size looks exactly as blurry as you'd expect.
Step 3: Refresh the link when the numbers change
Three ways, depending on how many linked objects you're dealing with:
- Right-click the object on the slide and choose Update Link to refresh just that one.
- Go to File > Info > Edit Links to Files and click Update Now to refresh every linked object in the deck at once.
- Just reopen the .pptx after the Excel file has changed - PowerPoint asks whether to update the presentation with data from the linked files. Click Update Links.
None of this happens on its own. Saving the workbook doesn't reach into PowerPoint and change anything - PowerPoint has to ask Excel for the current numbers, which means someone has to trigger that ask.
Common mistakes
Pasting before the workbook has ever been saved.
Paste Special still lets you paste, but Paste Link is greyed out for an unsaved file, because there's no path on disk yet to link to. Save the workbook first, even under a placeholder file name, then copy.
Moving or renaming the Excel file after the link exists.
The link stores an absolute file path, not a reference to "whichever workbook I copied this from." Move the file into a different folder, rename it, or migrate it from a local drive to OneDrive later, and the link breaks silently. The slide keeps showing whatever numbers it last had, with no warning until someone opens Edit Links to Files and sees the broken status. Put both files in their final folder before you build the link, ideally a synced OneDrive or SharePoint folder if the deck might get opened on a different machine.
Forgetting this is a pull, not a push.
The workbook doesn't notify PowerPoint of anything. If the deck isn't open at the same time you edit the numbers, it stays stale until someone opens it and accepts the update prompt, or right-clicks Update Link. "Self-updating" means "updates when asked," not "updates by itself in the background."
Frequently Asked Questions
Does this work if the Excel file lives on OneDrive or SharePoint instead of a local drive?
Generally yes, since OneDrive syncs a real local copy that Paste Link can point to. It gets less reliable if the file is Files On-Demand and not fully downloaded, or if two people opening the deck have their OneDrive folder synced to different drive letters or paths, because the link resolves against whichever local path existed when you created it.
Does the slide update the instant I change a number in Excel?
No, unless both files happen to be open at the same time, in which case PowerPoint picks up the change almost immediately. Otherwise it updates the next time someone reopens the deck and accepts the prompt, or manually clicks Update Link.
Can I link a chart the same way, not just a range of cells?
Yes, and it's arguably the more common use of this feature. Copy the chart instead of a cell range, then use Paste Special, Paste Link, and choose Microsoft Excel Chart Object.
What happens if I send the PowerPoint file to someone who doesn't have the Excel file?
The last-updated numbers stay baked into the slide. They just can't refresh it, and depending on their Trust Center settings, PowerPoint may warn them it can't reach the linked file.
Does this work in PowerPoint for the web or on Mac?
Not reliably. Paste Special's link options are a Windows-desktop feature, and Microsoft's own documentation flags that many Paste Special formats aren't available on the web or in some Mac builds. Build and maintain the link on Windows desktop PowerPoint.
What if I want to link an entire worksheet instead of a few cells?
Use Insert tab > Object > Create from File, browse to the workbook, tick Link, and click OK. It always displays whichever sheet was active the last time you saved the workbook, so make sure that's the one you want before you save.
Where to go from here
If this needs to go out to fifty inboxes on a schedule instead of being opened by one person before a meeting, that's a job for Build a Power Automate Desktop Flow That Exports a Report and Emails It Daily at 7am, not a linked slide.
And if you've ever had an automation quietly break because someone moved a file it depended on, The Flow Ran Perfectly for Two Months. Then It Didn't. is the longer version of the lesson Step 2's common mistakes just gave you in miniature.
The Hot Take on why nobody reads your 40-slide deck (15 Jul) makes the case for why three linked numbers on one slide beats forty slides nobody opens in the first place.