Excel to PowerPoint Linked Cells: How to Link and Update

How-to basics · Updated November 18, 2026

To link Excel cells to a PowerPoint slide in Microsoft 365 for Windows, select and copy the cells in Excel, then in PowerPoint choose Home > Paste > Paste Special, select Paste link, choose Microsoft Excel Worksheet Object, and click OK. The slide then refers to the source workbook, so you can update the displayed data when the Excel file changes.

What a linked Excel range actually is

PowerPoint does not turn a slide into an Excel worksheet with editable cells. Instead, it places a linked representation of the copied range on the slide. That representation can display the values and layout from Excel, while the source workbook remains the place where you edit the underlying cells. Depending on the paste format, you may be able to open the source data in Excel by double-clicking the object.

This is different from copying and pasting normally. A regular paste creates a separate copy in the presentation; changing the workbook later will not change that copy. A linked paste keeps a connection to the workbook file, allowing PowerPoint to retrieve updated content. It is also different from typing a formula in a PowerPoint cell: PowerPoint slides do not have Excel-style worksheet cells.

For example, suppose a quarterly report slide contains the range A1:D6 from a workbook. If sales figures change in that workbook, the linked object can be refreshed to show the new figures. The slide does not necessarily refresh the instant someone edits Excel, however. Updates may happen when the presentation opens, when you accept an update prompt, or when you update the link yourself.

How to link a range of cells in Windows

Keep the Excel workbook saved before creating the link. Copy the exact cells you need, rather than entire rows or columns, so the object stays a manageable size and does not include irrelevant blank space. Then use these steps in the desktop apps:

  1. In Excel, select the cell range and press Ctrl+C.
  2. Switch to PowerPoint and select the slide where the range should appear.
  3. On the Home tab, open the Paste menu and choose Paste Special.
  4. In the dialog, select Paste link, select Microsoft Excel Worksheet Object, and choose OK.
  5. Resize and position the linked object on the slide. Save the presentation and keep the source workbook available.

The Paste Special dialog may offer other formats, and the available choices can depend on the selection and Office build. Microsoft Excel Worksheet Object is a practical choice when you want a linked range that retains its spreadsheet-object behavior. If you need a highly controlled visual appearance, test the available linked formats on a sample slide before building the full deck.

On a Mac, copy the range in Excel and use PowerPoint’s Edit > Paste Special command, then choose Paste link if it is offered for the format you want. Ribbon and dialog labels can differ between Mac releases. If Paste link is unavailable, check that you copied a supported Excel selection and are using the desktop applications; do not assume an ordinary paste has created a link.

Linking an Excel chart instead of cells

If the slide needs a chart, copy the chart itself in Excel rather than copying the cells that feed it. In PowerPoint, use Home > Paste > Paste Special, select Paste link, and choose an available Excel chart or object format. Linking the chart lets the slide display the chart while the workbook remains the source for its data. The exact wording of the format choice can vary with the copied chart and Office version.

This approach is useful when the chart’s series, labels, or values are revised in Excel. It is not the same as rebuilding a chart independently in PowerPoint, where the presentation may contain its own data sheet. If the chart is already in the workbook, linking it avoids maintaining two separate chart versions. Before sharing, check that the chart is legible at slide size and that its colors and labels work with the presentation theme.

Choose a linked range when readers need a table or selected figures. Choose a linked chart when the visual trend matters more than the exact cell layout. In either case, make a deliberate selection: extra blank rows, hidden columns, or unwanted headings can affect what the audience sees.

Updating linked content

When the workbook changes, PowerPoint may ask whether to update links as the presentation opens. Choose Update Links when you want the slide to retrieve the latest source content and you trust the workbook location. If you dismiss the prompt or want to refresh later, the Windows desktop app provides link controls under File > Info > Edit Links to Files when the presentation contains recognized file links. Select a link and use the available update command, such as Update Now.

Menu availability can vary with the version, file type, and whether PowerPoint recognizes the link as a file link. You can also right-click a linked object and look for a link update command, if one is available. For a recurring presentation, update the Excel workbook first, save it, then open or refresh the PowerPoint presentation and check that the displayed values are correct before presenting.

Refreshing a link retrieves content; it does not guarantee that every change to the source workbook will be reflected exactly as expected. For instance, a changed range size or revised formatting can alter the object’s dimensions or appearance. Review the slide after updating, especially if the table sits close to other content.

File locations, sharing, and link reliability

A linked object depends on PowerPoint being able to find its Excel source. If the workbook is renamed, moved, deleted, or stored somewhere a recipient cannot access, the connection may fail or PowerPoint may continue showing the last saved display. Links created with a local folder path are particularly easy to break when a presentation moves to another computer.

For a handoff, keep the workbook and presentation together in a clearly named folder, and test the presentation from the folder or location the recipient will use. When working with OneDrive or SharePoint, make sure collaborators have access to the source file and test the link in the desktop apps they will use. Cloud storage and organizational settings can affect access, so a link that works for the person who created it should not be assumed to work for every recipient.

PowerPoint’s Edit Links to Files controls can help you inspect or change a recognized source path. Use Change Source if the workbook has moved and you know its new location. If the presentation must stand alone, consider breaking the link or replacing the object with a static copy, but understand that doing so removes the ability to refresh it from Excel.

Formatting, sizing, and editing trade-offs

A linked range is not automatically a perfect slide-ready table. Excel column widths, fonts, borders, number formats, and background colors may not fit the slide dimensions. Adjust the source range in Excel before copying, then check the result in PowerPoint at presentation size. A table that looks clear at 100 percent zoom on a laptop can be difficult to read from the back of a room.

Resizing the object in PowerPoint can change how much of the range is visible or how large its text appears. Avoid stretching it unevenly, which can distort the display. If the linked object is too dense, show fewer rows or columns, split the information across slides, or use a chart. For a simple visual that never needs updating, a picture can preserve the appearance more reliably, though it is not an editable linked table.

Double-clicking a linked worksheet object may open or activate the workbook content for editing, depending on the setup. That is convenient for maintenance but can surprise someone who expects to edit only slide text. Make it clear to collaborators which workbook is authoritative, and avoid making conflicting edits to the workbook and a separate copied table.

Linked, embedded, or static: which should you choose?

  • Linked object: Use it when the workbook is the maintained source and you expect figures to change. It can be refreshed, but it depends on the source file remaining accessible.
  • Embedded object: Use it when you want Excel content stored inside the presentation. It can be edited from PowerPoint, but edits are made to the embedded copy rather than automatically changing the original workbook.
  • Static paste or picture: Use it when the slide’s appearance matters and the information will not need to refresh. It is usually simpler to distribute, but source changes will not flow into the slide.

These choices solve different problems. Linking favors maintainability; embedding favors carrying an editable copy with the deck; a static image favors predictable appearance. A linked object is not inherently safer or more current: its value depends on source access and someone refreshing it at the right time. For a report that will be sent outside an organization, a static final snapshot may be less fragile, while an internal working deck may benefit from links.

Common problems and practical fixes

  • The slide does not change after editing Excel: Save the workbook, then update the link in PowerPoint. Confirm the object points to the workbook you changed.
  • PowerPoint cannot find the source: Restore the workbook to its expected location or use Edit Links to Files and change the source path. Confirm the recipient has permission to access it.
  • Paste link is missing: Copy the range again and open Paste Special in the desktop app. The options depend on what was copied; an ordinary paste does not create a live link.
  • The table is clipped or unreadable: Reduce the selected range, improve the source layout, or give the content more slide space. Check the slide in presentation view.
  • The deck opens with an update prompt: Decide whether to update from the trusted workbook. If the source should no longer be consulted, use a static copy or break the link.

A useful quality check is to change one harmless test value in a copy of the workbook, save it, update the presentation, and confirm that the intended object changes. This helps distinguish a real link from a pasted snapshot before the deck is shared. Do the test on copies if the workbook contains production data or is used by other people.

Frequently Asked Questions

Can Excel cells update automatically in PowerPoint?
They can update through a link, but do not assume changes appear instantly. PowerPoint may prompt when opening the presentation, and you can refresh a recognized link through its link controls. Save the workbook first and verify the slide after updating.

How do I link only one Excel cell to PowerPoint?
Copy that single cell in Excel, then use PowerPoint’s Paste Special command and choose Paste link with a suitable Excel format. The linked object may have more visual framing than a normal text box, so check its size and alignment on the slide.

Can I edit linked Excel cells directly in PowerPoint?
You can often open or activate the linked worksheet object by double-clicking it, but the source workbook remains the data source. For dependable editing, make changes in the workbook, save it, and update the link in PowerPoint.

Will the link work if I email the PowerPoint?
Only if the recipient can access the linked workbook at the location PowerPoint expects. Include or share the source file with appropriate permissions, and test the deck from the recipient’s setup. Otherwise, send a static version or embed the content when an independent copy is more appropriate.

How do I remove a link but keep the displayed content?
In Windows PowerPoint, open File > Info > Edit Links to Files, select the link, and choose Break Link if that control is available. The displayed content is generally retained as a static object, but it will no longer refresh from Excel. Save a copy first if you may need the live connection later.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.