Yes. In PowerPoint for Microsoft 365 on Windows, copy the cells in Excel, then choose Home > Paste > Paste Special, select Paste link, and choose Microsoft Excel Worksheet Object. This creates a link to the selected Excel range, so PowerPoint can refresh its displayed contents; it is a linked Excel object, not a native PowerPoint table.
How to link an Excel range to PowerPoint
Save the Excel workbook before you start, and keep it in a location that will remain accessible to PowerPoint. Then select the exact cells you want to show. You can select a rectangular range with its headings, such as A1:D8, or select a smaller block for a compact summary. Copy the cells and switch to the target slide in PowerPoint.
- In Excel, select the cells and press Ctrl+C. On a Mac, press Command+C.
- In PowerPoint, choose Home > Paste > Paste Special. Depending on the ribbon layout, Paste Special may be available from the Paste dropdown.
- In the dialog, choose Paste link, select Microsoft Excel Worksheet Object, and choose OK.
- Resize and position the object on the slide. Double-clicking it may open the linked workbook content for editing, depending on the Office version and object state.
Before sharing the presentation, save it, close and reopen it, and check that the link still displays the expected range. If PowerPoint asks whether to update links, allow the update when you trust the workbook and want the latest saved data. Menu labels and available paste formats can vary slightly with Office updates.
What a linked table is—and what it is not
A linked Excel range gives PowerPoint a reference to data in a separate workbook. The slide displays the selected cells, including their spreadsheet formatting, while the source values remain in Excel. When the source changes and the link is refreshed, the displayed range can reflect those changes.
It is important to distinguish this object from a native PowerPoint table. A native table is made of PowerPoint cells that you can edit directly with PowerPoint’s table tools. A linked Excel object retains its connection to the workbook, but it does not behave like a set of native PowerPoint cells. You may be able to open or edit the Excel content from the slide, but you cannot assume that every table-specific PowerPoint feature will be available.
Linking also does not mean that PowerPoint automatically includes every future row in the source sheet. The link normally refers to the range selected when it was created. If you selected A1:D8 and later add a ninth data row, check whether the linked object includes it; do not assume the selection expands. For a report whose size changes often, plan to update or recreate the linked range as needed.
Choose between linking, embedding, and a static paste
The right paste method depends on whether ongoing updates matter more than portability or direct slide editing. These options solve different problems:
- Paste Link: Choose this when the Excel workbook is the authoritative source and you want the slide to reflect later changes after an update. The presentation depends on the source file being available.
- Embed the workbook: Choose an embed option when you want the spreadsheet content stored inside the presentation. The embedded copy can travel with the file, but it is a separate copy and will not stay synchronized with the original workbook.
- Paste as a picture: Choose a picture when appearance matters and viewers do not need to edit the cells. It is easy to position, but its values do not refresh from Excel.
- Paste as a PowerPoint table or text: Choose this when you need to edit individual cells or text in PowerPoint. Treat it as a snapshot: later Excel changes do not automatically flow into it.
PowerPoint may show several paste choices after you copy cells, and the labels depend on the content and Office version. Read the choice carefully: an option that mentions embedding is not the same as Paste Link. If a living connection is essential, use the Paste Special dialog and verify that Paste Link is selected before confirming.
How updates work
A linked object is a connection, not a guarantee that the slide changes at the instant someone edits Excel. PowerPoint may update links when the presentation opens, may show a prompt, or may require a manual update. The exact behavior can depend on link settings, the Office build, and security policies. Save the workbook’s latest changes first, then refresh the link in PowerPoint so the presentation can read the saved source.
To refresh a single object, right-click it and look for an update command such as Update Link. Some versions also provide link-management controls through File > Info > Edit Links to Files when the presentation contains external links. If that command is unavailable, use the object’s context menu or inspect the link options in your version of PowerPoint. A linked object may also offer Edit Link or Open Link for changing or opening its source.
For recurring reports, use a simple handoff routine: update and save Excel, open the presentation, refresh the linked object, inspect the slide, and save PowerPoint. Check the displayed totals and headings rather than relying only on the absence of an error message. A link can refresh successfully while still pointing at an outdated range or an unintended workbook copy.
Keep the link working when you move or share files
A linked presentation needs to locate its source workbook. Moving, renaming, or deleting that workbook can break the connection, and sending only the PowerPoint file may leave recipients without access to the data. Access also matters: a recipient may be unable to refresh a workbook stored in a folder, network location, or cloud account they cannot open.
Before distributing a deck, decide whether recipients should see a live connection or a fixed result. For a live connection, put the workbook somewhere the intended audience can access, preserve its location and name, and test the presentation from a recipient-like account or device if practical. A shared OneDrive or SharePoint location can help when collaborators have the required permissions, but do not assume that sharing the presentation automatically grants access to every linked source.
If the audience only needs to see the figures as approved at a particular point in time, a static paste or picture may be safer. It avoids a broken external connection and prevents a later workbook edit from changing what the audience sees after a refresh. Keep a separate copy of the source workbook for recordkeeping if the figures need to be traceable.
Common problems and practical fixes
- The link is missing or broken: Confirm that the original workbook still exists, that it has not been renamed or moved, and that you have permission to open it. Re-copy the range and create the link again if the path cannot be repaired.
- The slide shows old values: Save the workbook, then use the linked object’s update command. If the source has unsaved changes, another application or presentation may still read the last saved version.
- New rows do not appear: The linked object may cover only the original selected cells. Recreate the link using the larger range, or update the selection in Excel and replace the object.
- The object looks too small or clipped: Resize it on the slide and check that the copied range is not wider or taller than the available space. A large worksheet range can become unreadable when reduced to fit a slide.
- PowerPoint displays a security prompt: Links to external files can trigger warnings or be restricted by organizational settings. Update only links from sources you trust, and ask your Microsoft 365 administrator about managed security policies rather than disabling protections indiscriminately.
A useful design check is to view the slide at presentation size, not only while zoomed in. If column headings become illegible, reduce the range to the data the audience needs, split a wide table across slides, or create a chart or summary instead.
Windows, Mac, and PowerPoint for the web
The steps above are for PowerPoint and Excel for Microsoft 365 on Windows. On a Mac, copying cells uses Command+C rather than Ctrl+C, and the Paste Special options and menu placement can differ by Office version. Look for Paste Special and a Paste Link option after copying the range. If your Mac version does not offer the required link format, do not choose an embed or picture option thinking it will behave the same way; use a supported desktop version or choose a deliberate static alternative.
PowerPoint for the web has different capabilities from the Windows desktop application, particularly for managing external links and linked objects. If a deck contains a link, use the desktop app to create or troubleshoot it when the web interface does not expose the needed commands. A recipient can also have a different experience depending on the platform, permissions, and whether the source workbook is reachable.
Frequently Asked Questions
Can I link Excel data to a native PowerPoint table?
Not as a continuously linked set of ordinary PowerPoint table cells using the standard Paste Link method. That method creates a linked Excel worksheet object. A native PowerPoint table is convenient to edit on the slide, but treat pasted values in it as a snapshot unless you replace or update them yourself.
Will a linked Excel table update automatically?
It can be refreshed from its source, but automatic behavior is not guaranteed in every setup. PowerPoint may prompt on opening or require a manual update, and security settings can affect external links. Save the workbook and verify the slide after refreshing.
Can I add rows to the Excel range later?
Rows outside the range selected at the time of linking may not appear. If the table grows, check the displayed object and recreate or adjust the linked range so it includes the new rows and columns.
Does the recipient need the Excel workbook?
For a working external link, the recipient needs access to the source file at a location PowerPoint can reach. If they only need to view a fixed result, use a static paste or picture instead, or provide the workbook and ensure its access and location are handled deliberately.
Can I edit the linked data from PowerPoint?
You may be able to open or edit the linked Excel object from the slide, but the data belongs to the workbook rather than to a native PowerPoint table. Make changes in the correct source workbook, save it, and refresh the presentation to show the updated result.
Related
- How to Resolve a Corrupted Excel File Without Losing Data
- How to Quickly Group Rows in Excel with the Outline Tools
- How to Quit Excel When It’s Not Responding
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Extract Data From a Corrupted Excel File: Safe Methods That WorkTo extract data from a corrupted Excel file, first make a copy of it, then in Excel for…
- How to Indent in Google Sheets: Simple WorkaroundsGoogle Sheets does not provide a standard Increase Indent button for cell contents. To create a visible indent,…
- How to Accept All Track Changes in WordTo accept every tracked edit in a Word document, open the Review tab, open the Accept menu, and…
- How to Create Mailing Labels in WordTo create mailing labels in Word, open the Mailings tab, choose Start Mail Merge > Labels, select the…
- How to Open the Visual Basic Editor in ExcelIn Excel for Microsoft 365 on Windows, press Alt+F11 to open the Visual Basic Editor (VBE), or choose…
- Mail Merge in Word: A Step-by-Step GuideTo do a mail merge in Word, prepare a recipient list, connect it to a Word document, insert…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.