Which of these can be edited with Excel and changes the data in your source file

Embedding or linking an Excel file in PowerPoint presentations can be confusing to beginners. However, Microsoft has done its very best to make the sharing process between these two apps as easy and as stress-free as possible.

In this tutorial, you will learn how you can embed or link an Excel file, data or chart into your PowerPoint slides.

But first, before we dive into the main tutorial, I’d like to highlight the differences between embedding and linking Excel files in PowerPoint. These terms may sound interchangeable but they do have major differences as you can see in the table below.

Difference Between Embedding And Linking Excel Files To PowerPoint

Section 1. How To LINK An Excel File In PowerPoint (All Updates in Excel Are Automatically Pushed To PowerPoint)

In this section, I will discuss two methods. The first one is how to link an entire Excel spreadsheet (this includes both data and charts if any). The second one is how to link just partial data or chart to your presentation.

Method 1. How To Link An Entire Excel Spreadsheet

1. Do this step in Excel first: save the spreadsheet you want to link to your PowerPoint. When saving make sure that this spreadsheet is the first one you see when you open your Excel file (this step is especially important if you have many spreadsheets in the Excel workbook).

2. In PowerPoint, click on Insert > Object.

3. In the Insert Object dialog box, click on ‘Create from file’ then browse to the Excel file you want to use. Don’t forget to click on the ‘Link’ box so that any updates you make to the Excel file gets automatically applied to your PowerPoint.

4. Click on the OK button to complete the linking process. This is what the linked Excel spreadsheet looks like on our PowerPoint slide. As you can see, it included both the raw data in table format as well as the chart I made in Excel.

5. If you need to edit the data, you can double-click on the linked file and you will be taken directly to Excel so you can edit the file. All edits you make in Excel will automatically be pushed to your slide(s).

Method 2. How To Link Partial Data or Chart In Excel To PowerPoint

In this method, I am going to show you how you can link only a section of data in your spreadsheet. Remember that in Method 1, I used a sample spreadsheet with 5 columns. Here in this method, I will link only 2 columns.

1. In Excel, highlight the data you want to link to PowerPoint and click on CTRL+C on your keyboard. Alternatively, you can right-click on your mouse then click on Copy. For this example, I highlighted Column 1 and Column 2, like below:

2. In PowerPoint, go to the Home tab, click on the small arrow below Paste to show more options, then select Paste Special.

3. In the Paste Special dialog box, click on Paste Link > Microsoft Excel Worksheet Object.

Take note of the Source file in this image (Microsoft Excel Worksheet)

4. Click on OK to finish the linking process. Your linked data will look something like this:

5. If you want to link a CHART from the partial data, you will need to create the chart first in Excel. Then click on Copy. In this example, I am copying ONLY this chart that was created from the 2-column data.

6. This is what happens when I use the Paste Special method in PowerPoint (just like in steps 2 and 3):

Take note of the Source file in this image (Microsoft Excel Chart)

7. This is what the final linked chart for our 2-column data looks like on PowerPoint:

Just like in Method 1, if you need to update the data, just double click on the Excel data or chart on your PowerPoint slide and you will automatically be directed to Excel to work on the edits. All updates in Excel are automatically pushed to PowerPoint.

Section 2. How To EMBED An Excel File In PowerPoint (Updates In Excel Are NOT Automatically Pushed To PowerPoint)

In this section, I will discuss two methods. The first one would be to how to embed Excel data and the second one would be how to embed a chart in your PowerPoint presentation.

Method 1. How to Embed Excel Data In PowerPoint

1. Highlight the data you want to copy in Excel. Then press CTRL+C on your keyboard OR right-click on your mouse then select Copy.

2. In PowerPoint, right-click on the slide where you want to add the Excel data OR go to Home > Paste > Paste Special. You will then see 5 icons like this in Paste Options:

Icons you will see if you’re copying DATA from Excel

• First option – Use Destination Styles

Use this option if you want your data to use the format or theme of your presentation. Note how the table background is light blue. This is because of the default Office theme color I’m using.

• Second option – Keep Source Formatting

Use this option if you want your data to use the format of your Excel spreadsheet (not your PowerPoint theme). Since my Excel spreadsheet just has a plain white background, this is how my data looks in PowerPoint, too. If I change the background in Excel to yellow, then the table below will also have a yellow background.

• Third option – Embed

Use this Embed option if you want to copy AND edit your data in Excel later. Note that this option will also use Excel’s format, not PowerPoint, just like the second option above.

• Fourth option – Picture

Use this option to paste your Excel data as an image or picture in PowerPoint. This is the best option if you don’t want other people to edit your data.

• Fifth option – Keep Text Only

Use this option if you only want to copy the text from your data (no formatting at all). The cell values will be separated by tab spaces and each row will be in a separate paragraph.

Method 2. How to Embed An Excel Chart In PowerPoint

1. Highlight the chart you want to copy in Excel. Then press CTRL+C on your keyboard OR right-click on your mouse then select Copy.

2. In PowerPoint, right-click on the slide where you want to add the Excel chart OR go to Home > Paste > Paste Special. You will then see 5 icons like you see in the screenshot below in Paste Options:

Icons you will see if you’re copying Charts from Excel

• First option – Use Destination Theme & Embed Workbook

Use this option if you want your chart to use your PowerPoint file’s theme and formatting. This allows your chart to blend in nicely with the rest of your slides.

• Second option – Keep Source Formatting & Embed Workbook

Use this option if you want to use your Excel file’s formatting. This means that the chart will look exactly the same in PowerPoint and Excel.

• Third option – Use Destination Theme And Link Data

Use this option to use your PowerPoint file’s formatting and keep the chart linked to the original Excel file.

• Fourth option – Keep Source Formatting And Link Data

Use this option to use your Excel file’s formatting and keep the chart linked to the original Excel file.

• Fifth option – Picture

Use this option to paste your Excel chart as a picture. You can’t edit the chart but you can replace it with another image and apply picture formatting.

Final Words On Embedding and Linking An Excel File In PowerPoint

As I have shown in this tutorial, there are quite a number of ways to share and present your Excel file in PowerPoint. Just remember the main differences between linking and embedding content from Excel to PowerPoint. You will have to decide for yourself which of these options are best used in your specific situation.

At 24slides, we create world-class presentation designs, animations, and infographics. Take a look at some of our examples and get an instant quote.

You might also find this interesting: Tutorial – Save Your PowerPoint As A Video