How to Insert Excel in PowerPoint and Keep it Linked

by
In PowerPoint, on the Insert tab, click or tap Object. In the Insert Object dialog box, select Create from file. Click or tap Browse, and in the Browse box, find the Excel workbook with the data you want to insert and link to. Before you close the Insert Object box, select Link, and click OK.
Read more at support.microsoft.com

Do you spend a lot of time copying and pasting data from Excel to PowerPoint? If so, there is a better way. By linking an Excel spreadsheet to a PowerPoint presentation, any updates made in Excel will automatically update in PowerPoint.

In this tutorial, we will show you how to insert Excel in PowerPoint and keep it linked. First, open both Excel and PowerPoint. In this example, we have a quarterly performance review PowerPoint deck and we want to update a table with data from Excel.

To link the table, highlight the table in Excel and click on “Copy”. Then, in PowerPoint, click on the drop-down under “Paste” in the top left-hand corner and select “Paste Special”. Choose “Paste Link” and then “Microsoft Excel Worksheet Object” to insert the table as a linked object.

Now, any changes made in Excel to the source data will automatically update in PowerPoint. To make changes to the table within PowerPoint, simply double click on the table to open the source Excel sheet. However, any formatting changes must be made in Excel as they will flow through to PowerPoint once updated.

Next, we will show you how to link an Excel chart to a PowerPoint slide. Copy the chart in Excel and paste it into PowerPoint. Again, click on the drop-down under “Paste” and select “Paste Link”. Choose the option to link to the source theme to ensure it is connected to the original data in Excel.

Any changes made in the source data in Excel will automatically update the chart in PowerPoint. To make changes to the chart, right click on it and select “Edit Data” to open the source Excel sheet. Keep in mind that any formatting changes must be made in Excel as they will not flow through to PowerPoint.

By following these simple steps, you can save time and ensure that your PowerPoint presentation is always up-to-date with the latest data from Excel.

FAQ

How do you embed a spreadsheet in PowerPoint?
Open a presentation file. On your desktop, double-click the icon for Microsoft PowerPoint to retrieve a blank presentation. ... Click the "Insert" tab. ... Select "Create from file" ... Find an Excel document. ... Check the "Link" box.
Read more on www.indeed.com
How do I fit an Excel table into PowerPoint?
Move your cursor to the spreadsheet's bottom right edge. The cursor will change into a diagonal arrow, pointing in two directions. When it changes to that shape, click and drag the cursor to make the spreadsheet smaller. Release the button when the spreadsheet fits inside the slide.
Read more on smallbusiness.chron.com
How do I copy a table from Excel to PowerPoint with formatting?
Right-click the copied cells and select Copy. In your PowerPoint presentation, right-click and select the Paste Options you want: Use Destination Styles – Choose to edit your copied cells like a PowerPoint table, but with PowerPoint's color scheme and fonts.
Read more on support.microsoft.com
How do I open an Excel file in PowerPoint presentation mode?
From the desktop, right-click your PowerPoint file, then select Show from the drop-down menu. Your file will open in Slide Show mode, where you can present it. To leave your presentation, just press Escape to return to the desktop. Watch the video below to see how quickly you can open a file in Slide Show mode.
Read more on edu.gcfglobal.org