To create an Excel-to-PowerPoint link in Microsoft 365 for Windows, copy the cells or chart in Excel, then in PowerPoint choose Home > Paste > Paste Special, select Paste link, and choose the Excel object format. The slide then refers to the source workbook, so you can update the presentation when that workbook changes instead of replacing the content by hand.
What an Excel-to-PowerPoint link does
A linked object displays Excel content on a PowerPoint slide while retaining a connection to the workbook that supplied it. Depending on the paste option, the slide can show a cell range, a chart, or another Excel object. PowerPoint keeps a display of the linked content, but the Excel workbook remains the source of the data.
This is different from simply copying and pasting. A regular paste creates a separate copy in the presentation: later edits to Excel do not flow through. A link can be refreshed to reflect source changes, although refreshes may require confirmation or a manual update. The link also depends on PowerPoint being able to find and access the source workbook.
For example, imagine a monthly sales chart in Excel that is placed in a presentation for a team meeting. If the chart is linked, changing the figures in the workbook and updating the link can refresh the chart on the slide. The slide is not a live window into Excel, however: it shows the linked object as last updated, and viewers may need access to the workbook for the link to remain usable.
Link a cell range or table
Use this process when you want a block of worksheet cells on a slide. First, save the workbook in a location that will remain available. Select only the cells you want to show, and copy them. In PowerPoint, open the target slide, then use Home > Paste > Paste Special. In the dialog, select Paste link, choose Microsoft Excel Worksheet Object, and confirm. The precise list of formats can differ according to the copied content and Office version.
- In Excel, select the intended range and press Ctrl+C. Check that the selection does not include extra blank rows or columns that would make the slide object unnecessarily large.
- In PowerPoint, select the slide and open Home > Paste > Paste Special.
- Select Paste link, choose Microsoft Excel Worksheet Object, and select OK.
- Resize and position the object on the slide. Keep text large enough to read at presentation size; a wide worksheet range may be difficult to fit legibly.
Windows keyboard shortcuts can make the first part faster: Ctrl+C copies the selection. The Mac equivalent is Command+C. Paste Special is generally easiest to access from the PowerPoint ribbon; the dialog and available link formats can differ on Mac, so check whether Paste link is offered in your installed PowerPoint version. If it is not available, use a linked chart option if appropriate, or choose an alternative such as an image and plan to replace it when the data changes.
A linked worksheet object can preserve more of the Excel object’s behavior than a picture, but it is not always the best way to present a large table. Consider copying a concise, presentation-ready range rather than trying to fit an entire worksheet on one slide. If the goal is to show a small set of values with a specific layout, test the result at slide size and verify that fonts, number formats, and borders remain clear.
Link an Excel chart
For a chart, select the chart in Excel and copy it. In PowerPoint, choose Home > Paste > Paste Special, select Paste link, and choose Microsoft Excel Chart Object if that option appears. This keeps the chart tied to its Excel source, allowing a refresh to bring in changes to the underlying data or chart. You can also look for a paste choice such as Keep Source Formatting & Link Data or Use Destination Theme & Link Data; wording and availability can vary by Office build and copied content.
Choose the formatting option with the slide design in mind. Keeping source formatting retains more of the Excel chart’s appearance. Using the destination theme can make it fit the presentation’s colors and fonts, but the chart’s appearance may differ from the workbook. Either way, check titles, legends, axis labels, and data labels after pasting. A chart that is readable in Excel may become cramped when placed on a slide.
For instance, a quarterly revenue chart can remain linked while the workbook’s next quarter is added. If the chart’s source range or series does not include the new quarter, however, updating the link alone will not necessarily redesign the chart to include it. Confirm the chart itself is set up to include the intended data before relying on the slide.
Choose between linking, embedding, and a picture
Linking is useful when Excel remains the authoritative source and the PowerPoint content needs periodic refreshes. It is not automatically the right choice for every deck. The key trade-off is between keeping a connection to a separate file and making the presentation self-contained.
- Link: The slide refers to the Excel source. Changes can be brought into PowerPoint by updating the link. The source file must remain accessible, and moving or renaming it can break the connection.
- Embed: The workbook content is stored in the presentation rather than maintained as a connection to the original workbook. The presentation can be easier to move as a single file, but later edits to the original Excel file do not automatically update the embedded copy.
- Picture: The slide contains a static image. It is simple to share and will not change unexpectedly, but the displayed values and chart will not update from Excel. To reflect new data, make and paste a new image.
In PowerPoint, a normal paste or a paste option that says link is different from an embedded Excel object. If you need to edit the spreadsheet contents inside PowerPoint without relying on a separate live source, an embedded object may be suitable. If the audience only needs to see a fixed result, a picture can be more predictable. For recurring reports that depend on one controlled workbook, a link can save repetitive copying—but only if file access and update checks are part of the workflow.
Update and manage linked content
After the Excel workbook changes, open the presentation and check whether PowerPoint asks to update its links. If the linked object still shows old content, try selecting it and choosing Update Link from its context menu, where that command is available. On Windows, PowerPoint may also show Edit Links to Files under File > Info when the presentation contains links. That dialog can help identify the source and, where available, update the link or change how updates are handled.
Automatic updating can be convenient for a deck that is used alongside a stable source file. Manual updating gives you a chance to review changes before they appear in a presentation. The setting does not remove the need to verify the final slides: an updated chart might have new labels, changed proportions, or a longer category name that affects its layout.
For a dependable reporting routine, consider this checklist:
- Open the correct Excel workbook and make sure its data and charts are final.
- Open the PowerPoint file and respond to any link-update prompt deliberately.
- Review each linked object on the slide, especially charts and ranges with changing dimensions.
- Save the presentation after confirming the displayed values and formatting.
- If you send the deck to someone else, tell them whether they need the source workbook and how to access it.
Common link problems and fixes
The slide does not change. The object may be a normal paste, an image, or an older snapshot of a linked object. Check whether PowerPoint identifies it as a linked Excel object, then use Update Link or the link-management option if available. Also confirm that the source workbook contains the expected changes and that the link points to that copy rather than another file with a similar name.
PowerPoint cannot find the workbook. A moved, renamed, or unavailable source file can break the connection. Restore the workbook to its expected location or use the link-management controls to point PowerPoint to the correct source. Before sharing, do not assume that a link which works on your computer will work on a colleague’s computer; their account may not have access to the same folder or cloud location.
The content looks different after pasting or updating. Source formatting and destination-theme options produce different results, and the object may need to be resized. Check the slide in presentation view, not just while editing. For a range, reduce the amount of data or split it across slides if the type is too small to read. For a chart, inspect its legend and labels after each refresh.
A prompt appears when the presentation opens. PowerPoint may ask whether to update external links. Treat that prompt as a decision, not a routine click: update when you trust the source and want its current content; keep the displayed version when you need to preserve the approved snapshot. If a deck is being reviewed or distributed, confirm which state is intended before saving.
File sharing, access, and safer workflows
A linked slide is only as dependable as the route to its source. Keep the workbook in a stable location, and avoid casually renaming or moving either file after links are established. A link may point to a local path or a shared location; colleagues need suitable access to the source for updates to work. Test the deck from the same environment in which it will be presented, particularly if it is being moved between devices or accounts.
Links also matter for confidentiality. The visible range on a slide is not a substitute for checking who can access the source workbook. A recipient who has access to that workbook may be able to inspect more of it than the particular cells shown in the presentation. Share only the necessary source file and permissions, and remove confidential data from the workbook or provide a presentation-only copy when appropriate. Do not disable security prompts simply to make links update without review.
For a presentation that must travel independently, an embedded object or static image may be more robust. Another practical approach is to keep a linked working deck for internal updates, then create a final distribution copy using pictures or other nonlinked content after review. That separates the update workflow from the version intended for wider sharing.
Alternatives when a link is not the best fit
If your data changes often but the presentation needs a consistent visual design, create a chart in Excel, link it, and then verify its appearance in PowerPoint each reporting cycle. If only a few numbers change, a static table or image may be easier to control; replace it as part of the update checklist. If many linked items are involved, label or document the source workbook and the slides that depend on it so reviewers can check them systematically.
There is no single choice that guarantees both automatic updates and perfect portability. A link favors refreshability, an embedded object favors keeping content with the presentation, and a picture favors a fixed appearance. Choosing based on how often the data changes, who needs to edit it, and where the deck will be opened is more reliable than assuming that every paste is a link.
Frequently Asked Questions
Can Excel update PowerPoint automatically?
A linked object can be set to update automatically in some PowerPoint link settings, or PowerPoint can prompt you to update it. The source workbook must be available, and you should still inspect the slide after an update. A normal paste or picture will not refresh from Excel.
Why is Paste Link unavailable?
The option can depend on what you copied, the paste format, and the PowerPoint version or platform. Copy the actual Excel range or chart, then open Paste Special and check the available formats. If no suitable linked format is offered, use a static picture or another workflow rather than treating an ordinary paste as a link.
Can I link only one Excel chart to PowerPoint?
Yes. Copy the chart itself in Excel, then use Paste Special in PowerPoint and select Paste link with the Excel chart object format when available. This links that chart rather than requiring you to paste an entire worksheet range.
Will an Excel-to-PowerPoint link work for someone else?
It can, if the recipient’s PowerPoint can reach the source workbook and the recipient has permission to open it. A link to a file stored only on your computer will generally not be useful to someone on another device. Test access or send a presentation copy with embedded or static content instead.
Does linking let me edit the Excel data in PowerPoint?
A linked object can often be opened for editing in Excel, but its source remains the linked workbook. Editing the presentation does not turn the link into a separate, independently maintained copy. If you need the workbook stored within the presentation, consider embedding instead.
Related
- Data Validation Testing: Methods and Examples
- Data Validation Studio: Excel Rules, Setup, and Limits
- Power Query Circular Reference: Causes and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut to Highlight Cells: Fill Color GuideIn Excel for Microsoft 365 on Windows, press Alt, then H, then H to open the Fill Color…
- Excel Import Multiple CSV Files: Methods and TipsTo import multiple CSV files into Excel for Microsoft 365 on Windows, put the files in one folder,…
- Data Slicer in Excel: How to Add and Use OneA data slicer in Excel is a clickable on-sheet control that filters a table or PivotTable by the…
- Excel Flash Fill for Number Sequences: How It WorksExcel Flash Fill can sometimes extend a number pattern when you show it examples, but it is designed…
- Excel Workbook Format: XLSX, XLS, and Other TypesAn Excel workbook is usually saved in the .xlsx format, the standard format for modern versions of Microsoft…
- Copilot Not Responding in Excel? Fixes to TryIf Copilot is not responding in Excel, first confirm that you are signed in with an account and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.