To link Excel to PowerPoint, copy the cells or chart in Excel, then in PowerPoint use Paste Special, choose Paste link, and pick Microsoft Excel Worksheet Object. The slide now updates from the workbook when you right click and choose Update Link, or each time the deck opens. It works well for a few charts. It breaks when files move, which is why teams with many decks use a different kind of link.
Read the transcript
Here's a board deck. These numbers were typed in by hand, so let's connect them to Excel instead. Open the INSYNCR tab, and click Connections. Pick Microsoft Excel, and click Add. Now point it at your workbook. Next, add a query. That's just the part of the workbook you want to read. We'll choose the KPIs sheet. And there's your data, read straight from Excel. Now select the number on the slide, and click Text box. Your query is already picked. Set the column to Value, and row one. That's the revenue line. The preview shows the real number. Click OK. That's it. The number on this slide now comes from your workbook.
The video above shows a first connection to Excel. Below are the built in steps, why they break, and how teams keep many decks right.
What does linking Excel to PowerPoint actually do?
A linked object is a window onto part of a workbook. PowerPoint stores two things: a picture of the data, and the path to the file it came from. When you update the link, PowerPoint opens that path, reads the range again and redraws the slide.
That’s different from the other options:
- Pasting copies the values once. Nothing ever updates.
- Embedding puts a full copy of the workbook in the deck. It never breaks, but it never updates either.
- Linking updates, but only while the path still leads to the file.
For all four ways side by side, see how to insert, embed or attach Excel in PowerPoint.
How to link an Excel table or range to PowerPoint
These steps match PowerPoint for Microsoft 365 on Windows. On a Mac, use Cmd instead of Ctrl and find Paste Special under the Edit menu.
- Save the workbook in its final location, such as a shared folder. Links made before a move will break after it.
- Select the range and press Ctrl + C. Tip: give the range a name first (Formulas, Define Name). Named ranges survive inserted rows better than cell addresses.
- In PowerPoint, press Ctrl + Alt + V to open Paste Special.
- Choose Paste link, then Microsoft Excel Worksheet Object, and click OK.
- Resize the object on the slide. Don’t edit its contents in PowerPoint; change the workbook instead.
How to link an Excel chart so it updates
- In Excel, click the chart’s border and press Ctrl + C.
- In PowerPoint, press Ctrl + V and click the Paste Options button.
- Choose Use Destination Theme & Link Data to match your deck’s colours, or Keep Source Formatting & Link Data to keep Excel’s look.
- To refresh, click the chart, go to Chart Design and click Refresh Data.
Avoid the two Embed Workbook options if you want updates. They paste a frozen copy of the whole workbook into the deck.
How to update and manage Excel links in PowerPoint
One linked object is easy. Twenty need a plan. PowerPoint gives you one screen to manage them all.
- Save the deck, then go to File, Info.
- Bottom right, under Related Documents, click Edit Links to Files.
- Select a link and click Update Now to refresh it.
- Click Change Source to point a link at a new file, for example this month’s workbook.
- Tick Automatic Update to refresh that link every time the deck opens.
When a deck with links opens, PowerPoint shows a security notice. Click Update Links only if you trust where the deck came from.
Native links can’t put a live number inside a sentence, such as “Revenue rose to 4.2 million”. A linked object is always a box of cells. If your slides are full of numbers in text, that’s a job for an add in.
Why do Excel links in PowerPoint break?
Run through this checklist before you rebuild anything.
- The workbook moved or was renamed. Fix it with Change Source.
- A sheet was renamed or the range moved. Point the link at the new range.
- It’s a OneDrive or SharePoint file linked from your synced folder. The path exists only on your PC.
- Someone opened the deck without access to the source folder. They see old numbers.
- The update prompt was cancelled, or Automatic Update is off.
The video above fixes a broken link step by step. For every cause and its fix, read why Excel links break in PowerPoint.
How to link Excel to PowerPoint at enterprise scale
Linking is a feature. Reporting for a whole team is a process. Here’s what holds up when many people and many decks are involved.
Keep one source location
Put the source workbooks in one shared folder that never moves, and don’t let people work from copies on their desktops. Every link should point at the same place.
Give each report three owners
- Template owner: controls the layout, branding and slide order.
- Data owner: defines the numbers and checks the workbook.
- Publishing owner: decides when to refresh and who gets the deck.
Lock the structure of the workbook
Use named ranges and tables, and agree that sheet names don’t change once they’re linked. Most broken links start with a tidy up.
Test on someone else’s PC
A deck that refreshes on its author’s laptop proves very little. Open it on a colleague’s machine before every first send.
Decide when “live” is right
Operational dashboards benefit from frequent refresh. A board pack is usually better as an approved snapshot, refreshed once and then saved as PDF.
Know when Excel isn’t the right source
If several people need the same numbers, or the workbook is just an export from a database, link the deck to the database itself. INSYNCR’s Professional plan reads SQL Server, PostgreSQL, Oracle and Salesforce directly.
Native links or an add in: which fits your team?
| Paste Link (built in) | INSYNCR add in | |
|---|---|---|
| Cost | Free | From €99.99 a month per user, billed annually |
| Setup | Minutes per object | Minutes for a first link; longer for a full pack |
| Refresh | Per object, or on open | Whole deck in one click, or on a schedule |
| Numbers inside sentences | No | Yes |
| When the workbook moves | Repoint each link by hand | Repoint one connection for the whole deck, or use a relative path so deck and workbook move together |
| Data sources | Excel | Excel, SQL Server, SharePoint, Salesforce and 20 more |
| One deck per client or region | No | Yes, from one template |
| Mac | Yes | No, Windows only |
How INSYNCR links Excel to PowerPoint
INSYNCR is a PowerPoint add in. It keeps PowerPoint as the deliverable and turns the deck into a template that refreshes from your data.
- Install it. It appears as a tab in the PowerPoint ribbon after about five minutes.
- Open your existing deck and connect to the workbook.
- Click a chart, table or text box and link it to a range, table or single cell.
- Press Refresh. Every linked object updates, and your formatting stays put.
- Generate one copy per client, region or month with Snapshot, if you need that.
The video above links a chart and a table. Colleagues who refresh a deck someone else built need a Viewer licence, at €27 a month billed annually. Anyone can open the refreshed file.
It runs on Windows with PowerPoint 2016 or later. INSYNCR runs on your own PC and reads your sources with your own access; your data isn’t sent to us. IT can read the details on the For IT and procurement page.
7 day trial, full access, no credit card. Start the trial, or see the plans.
To build slides from rows of data rather than link existing ones, read how to create PowerPoint slides from Excel automatically. For one file per person, see mail merge in PowerPoint.
Frequently asked questions
How do I link Excel to PowerPoint so it updates automatically?
Paste with Paste Special, Paste link. Then go to File, Info, Edit Links to Files, and tick Automatic Update for each link. The slide refreshes each time the deck opens, as long as the workbook hasn’t moved.
Why does PowerPoint ask me to update links when I open the file?
It’s a security check for any deck that reads other files. Click Update Links if you trust the deck, or Cancel to keep the numbers it already shows.
Can I link one Excel cell into a PowerPoint text box?
Not with built in linking. Paste Link always creates an object, not text inside a sentence. Add ins such as INSYNCR can link a single cell into a text box.
How do I change the Excel file a PowerPoint deck is linked to?
Go to File, Info, Edit Links to Files, select the link and click Change Source. Repeat for each link, or use an add in that switches the source for the whole deck at once.
Does Paste Link work on a Mac?
Yes. Paste Special and Paste link work in PowerPoint for Mac. Links made on Windows often break on a Mac, though, because the file paths differ.

