Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

You can link data or formulas from a saved Excel spreadsheet to your presentation in PowerPoint for macOS. Any data that changes in the spreadsheet can be easily updated in your PowerPoint presentation.

Link an entire Excel workbook to PowerPoint

  1. In PowerPoint, on the Insert tab, click Object.

  2. In the Insert Object box, click From File.

    Insert Object box

  3. Find the Excel workbook with the data you want to link to, and click Insert.

  4. In the Insert Object box, select Display as icon, and then click OK.

    Important: The linked object in your presentation displays all the data from the active, top spreadsheet tab in the linked Excel workbook. When you save the Excel workbook, make sure the spreadsheet you want in your presentation is the one you see when you first open the workbook.

Link a section of data in Excel to PowerPoint

  1. In Excel, open the saved workbook with the data you want to insert and link to.

  2. Select and copy the area of data you want to link to.

  3. In PowerPoint, click the slide where you want to paste the copied worksheet data.

  4. On the Home tab, click the arrow next to Paste, and then click Paste Special.

    Paste Special on the Paste menu

  5. In the Paste Special box, select Display as icon, and under Paste as, select Microsoft Excel Worksheet Object.

Copy and paste (unlinked) Excel data in PowerPoint

In this case, the Excel data will not be linked to your PowerPoint presentation. You copy the data from an Excel worksheet and paste it into your presentation. The worksheet does not send automatic updates to PowerPoint.

  1. In Excel, open the workbook with the data you want to copy.

  2. Select the area of data you want to copy.

  3. In PowerPoint, click the slide where you want to paste the copied worksheet data.

  4. On the Home tab, click the arrow next to Paste, and then pick one of the following:

    • Use Destination Styles to copy the data as a PowerPoint table, using the format of the presentation.

    • Keep Source Formatting to copy the Excel data as a PowerPoint table, using the format of the spreadsheet.

    • Embed to copy the data as information that can be edited in Excel later.

    • Paste as Picture to copy the data as a picture that can't be edited in Excel.

    • Keep Text Only to copy all the data as a single text box.

Link an entire Excel workbook to PowerPoint

  1. In PowerPoint, on the Insert menu, select Object.

  2. In the Insert Object box, select Create from file.

    The Insert Object dialog box opens.

    Insert Object box

  3. Find the Excel workbook with the data you want to link to, select it, and click Insert.

  4. In the Insert Object box, select Display as icon, and then click OK.

    Important: The linked object in your presentation displays all the data from the active, top spreadsheet tab in the linked Excel workbook. When you save the Excel workbook, make sure the spreadsheet you want in your presentation is the one you see when you first open the workbook.

Link a section of data in Excel to PowerPoint

  1. In Excel, open the saved workbook with the data you want to insert and link to.

  2. Select and copy the area of data you want to link to.

  3. In PowerPoint, in the thumbnail pane, select the slide on which you want to paste the copied worksheet data.

  4. On the Edit menu, select Paste Special.

  5. In the Paste Special box, select Display as icon, and under Paste as, select Microsoft Excel Worksheet Object. Click OK.

Copy and paste unlinked Excel data in PowerPoint

In this case, the Excel data will not be linked to your PowerPoint presentation. You copy the data from an Excel worksheet and paste it into your presentation. The worksheet does not send automatic updates to PowerPoint.

  1. In Excel, open the workbook with the data you want to copy.

  2. Select the area of data you want to copy.

  3. In PowerPoint, in the thumbnail pane, click the slide on which you want to paste the copied worksheet data.

  4. On the Edit menu, select Paste.

    The data appears on the slide.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×