The two ways to put Excel data into PowerPoint, and when to use each one
You can embed an Excel file in PowerPoint in two ways: link the spreadsheet so changes in Excel automatically update your slides, or paste a static copy so the data stays frozen on the day you embed it. Which one you choose depends on whether your numbers will change after you present.
Linking works best when you are building a presentation that will live for months and the underlying data shifts regularly — a sales dashboard, a budget tracker, a project timeline. Static embedding works best when you are presenting a snapshot: last quarter's final numbers, a one-time analysis, a historical comparison that will not change.
Both methods take about two minutes. The difference is in what happens next: with a link, your slides update automatically when someone opens the file. With a static copy, they do not.
Key Takeaways
- Linking an Excel file means your PowerPoint slides will show updated numbers every time you open the presentation, but both files must stay in the same folder for the link to work.
- Pasting a static copy freezes the data on the day you embed it, so changes in Excel will not appear in PowerPoint, but the presentation works even if you move or delete the original spreadsheet.
- You can edit linked data directly in PowerPoint by right-clicking and choosing Edit Link, which opens the original Excel file in a new window.
- If you move your PowerPoint file to a different folder or send it to someone else, linked files will break unless you move the Excel file with it.
How to link an Excel file so it updates automatically
Open both PowerPoint and Excel on your screen at the same time. In Excel, select the cells or the entire sheet you want to embed — click the cell in the top-left corner, then hold Shift and click the cell in the bottom-right corner to select a range, or press Ctrl+A to select everything. Copy the selection with Ctrl+C.
Switch to PowerPoint and click on the slide where you want the data to appear. Go to the Home tab, click the arrow next to Paste (not the Paste button itself), and select Paste Special. A dialog box will open. Look for the option that says "Paste link" — it is usually a checkbox near the bottom. Check that box, then click OK.
The spreadsheet data will now appear on your slide. Every time you open the PowerPoint file, it will pull the current numbers from the Excel file. If someone changes a value in Excel and then opens your presentation, the slide will show the new number.
To edit the linked data, right-click on it in PowerPoint and select Edit Link. This opens the original Excel file so you can make changes. Save the Excel file, close it, and the PowerPoint slide updates automatically.
How to paste a static copy that stays the same
Open Excel and select the cells you want to copy — the same way as above. Press Ctrl+C to copy. Switch to PowerPoint, click on your slide, and go to Home > Paste Special again.
This time, do not check the "Paste link" box. Instead, look for an option that says Microsoft Excel Worksheet Object or just Paste without the link. Click OK. The data will appear on your slide as a frozen snapshot.
If you later change the numbers in Excel, the PowerPoint slide will not update. The data you pasted is now independent of the original file. You can move the PowerPoint file anywhere, delete the Excel file, or send the presentation to someone else — the embedded data will still be there and will still show the original numbers.
When a linked file breaks and how to fix it
A link breaks when you move the PowerPoint file to a different folder without moving the Excel file with it, or when you send the presentation to someone who does not have the Excel file in the same location. When you open the presentation, PowerPoint will show a message asking whether you want to update the links.
If you click "Don't Update," the slide will show the last numbers it saw. If you click "Update," PowerPoint will search for the Excel file and fail, then show an error or old data. To fix this, move the Excel file into the same folder as the PowerPoint file, or use the same folder structure on the other person's computer.
You can also break the link intentionally if you decide you no longer want the data to update. Go to the Data tab (in PowerPoint 2016 and later, this is under File > Info > Edit Links to Files), find the link, and click Break Link. The data will freeze at its current value and will no longer try to pull from Excel.
Embedding the entire Excel file as an icon
If you want someone to be able to open the full Excel spreadsheet from inside PowerPoint, you can embed the entire file as a clickable icon. Go to the Insert tab, click Object, and select Create from File. Browse to your Excel file and click Insert.
PowerPoint will place an icon on your slide. Anyone who opens the presentation can double-click that icon to open the full Excel file in a new window. This is useful when you want to show a summary on the slide but let people dig into the raw data if they want to.
The entire Excel file is now stored inside the PowerPoint file, so the presentation will be larger. You can move it anywhere and the Excel file will come with it — there is no link to break.
Choosing between linking and embedding based on your workflow
Use linking if: you are the only person editing the presentation, the Excel file lives in a shared folder that does not move, or you want your slides to always show the most recent numbers without you having to manually update them.
Use static embedding if: you are sending the presentation to someone else, you want the data to stay exactly as it was on presentation day, or you plan to move the files around later. Static embedding is also safer if the underlying spreadsheet is large or changes frequently — you avoid the risk of opening a presentation and seeing unexpected new numbers.
Use the full-file icon embed if: you want to include the complete spreadsheet for reference but do not need it to update, or you want people to explore the data themselves without you having to explain every cell.
Troubleshooting common problems
The linked data shows an error or old numbers: The Excel file has moved or been deleted. Move it back to the same folder as the PowerPoint file, or break the link and re-embed the data as a static copy.
The presentation is much larger than expected: You embedded the entire Excel file as an object rather than linking or pasting specific cells. Delete the icon and use Paste Special with a link or static paste instead.
The formatting looks wrong when I paste: Use Paste Special and choose the option that says Formatted Text (RTF) or Picture if you only care about how it looks, not whether it updates. This trades interactivity for appearance.
Someone opened my presentation and the numbers changed: You used a link, and someone edited the Excel file while the presentation was open. The link pulled the new numbers. If you do not want this to happen, use static embedding instead.
Frequently Asked Questions
Can I edit the embedded Excel data directly in PowerPoint?
If you used Paste Special with a link, right-click the data and select Edit Link to open the original Excel file. If you used static embedding, you cannot edit it in PowerPoint — you have to go back to the original Excel file, make changes, and re-embed the data.
What happens if I send my PowerPoint to someone and they do not have Excel installed?
If you used a link, they will see an error or old data. If you used static embedding or the full-file icon, they can still see the data, but they cannot edit it unless they have Excel. The icon embed will not open without Excel installed.
Can I embed data from a Google Sheet instead of Excel?
PowerPoint does not have a direct link option for Google Sheets. You can read the Google Sheet as an Excel file, embed that, but it will not update when the Google Sheet changes. For live updates, you would need to use a third-party add-in or manually re-read and re-embed the file.
How do I know if my embedded data is linked or static?
Right-click on the data. If you see an "Edit Link" option, it is linked. If you do not see that option, it is static. You can also go to File > Info > Edit Links to Files to see a list of all linked files in the presentation.
Will the embedded data print correctly?
Yes. Both linked and static embedded data will print exactly as it appears on the slide. If the data is linked and you print before opening the file, it will print the last saved version.