Will Excel Will Allow You To Get Partial Data From An External Database Such As Access?

Embedding or linking an Excel file in PowerPoint presentations tin can be confusing to beginners. Nevertheless, Microsoft has washed its very best to make the sharing process between these two apps as like shooting fish in a barrel and as stress-free as possible.

Click to download hundreds of free Powerpoint Templates

In this tutorial, you will larn how you tin embed or link an Excel file, information or chart into your PowerPoint slides.

But first, before nosotros dive into the master tutorial, I'd like to highlight the differences between embedding and linking Excel files in PowerPoint. These terms may sound interchangeable but they practise have major differences equally you can see in the table below.

Difference Between Embedding And Linking Excel Files To PowerPoint

Embedding

Linking

1. Bang-up for distributing PowerPoint files online as all the data from Excel is contained/stored in the PowerPoint file.

two. Any changes made to PowerPoint are not updated in the original Excel file.

3. You lot don't need to have the Excel file open BUT it nonetheless has to exist accessible on your estimator.

four. Since the Excel data is stored locally in the PowerPoint file, the file size likewise increases. This tin can be a big trouble if you're embedding a lot of data, tables, and charts from Excel!

ane. Not so suitable for distributing your PowerPoint file online every bit y'all would also need to send the linked Excel file.

ii. All updates/edits to your Excel file are pushed automatically to your PowerPoint file.

iii. You volition need to take both Excel and PowerPoint open on your reckoner.

four. Does not inflate the PowerPoint's file size since the Excel information is not stored in the PowerPoint file.

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 start 1 is how to link an entire Excel spreadsheet (this includes both data and charts if whatsoever). The second 1 is how to link just partial information or nautical chart to your presentation.

Method 1. How To Link An Entire Excel Spreadsheet

1. Do this step in Excel starting time: save the spreadsheet you desire to link to your PowerPoint. When saving make sure that this spreadsheet is the starting time one you come across when you open your Excel file (this step is peculiarly of import if you have many spreadsheets in the Excel workbook).

2. In PowerPoint, click on Insert > Object.

How To Embed Or Link An Excel File In PowerPoint

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

iv. Click on the OK button to consummate the linking process. This is what the linked Excel spreadsheet looks like on our PowerPoint slide. As you tin see, it included both the raw data in table format likewise every bit the chart I made in Excel.

v. If y'all need to edit the information, you can double-click on the linked file and you lot will exist taken directly to Excel so yous tin can edit the file. All edits you make in Excel will automatically exist 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 testify you how you can link just a section of data in your spreadsheet. Retrieve that in Method 1, I used a sample spreadsheet with 5 columns. Here in this method, I will link simply two columns.

one. 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 Cavalcade i and Column 2, like beneath:

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

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

Accept note of the Source file in this paradigm (Microsoft Excel Worksheet)

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

five. If you want to link a CHART from the fractional data, you volition need to create the chart start in Excel. Then click on Re-create. In this case, I am copying But this nautical 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 two and 3):

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

7. This is what the last linked chart for our 2-cavalcade 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 nautical 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 talk over two methods. The first one would be to how to embed Excel information and the 2nd ane would be how to embed a chart in your PowerPoint presentation.

Method one. How to Embed Excel Data In PowerPoint

i. Highlight the data you want to copy in Excel. And 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 together the Excel data OR go to Dwelling > Paste > Paste Special. You will and so come across v icons like this in Paste Options:

Icons you will see if yous're copying DATA from Excel

Outset choice – Utilize Destination Styles

Use this option if you want your data to utilize the format or theme of your presentation. Annotation how the tabular array background is calorie-free blueish. This is because of the default Office theme color I'yard using.

Second pick – Keep Source Formatting

Employ this option if you want your data to employ the format of your Excel spreadsheet (non your PowerPoint theme). Since my Excel spreadsheet merely has a plain white background, this is how my data looks in PowerPoint, too. If I alter the background in Excel to xanthous, then the table below will likewise have a yellow background.

Third option – Embed

Utilize this Embed option if you want to copy AND edit your data in Excel later. Note that this selection volition besides use Excel's format, not PowerPoint, simply similar the second pick above.

Fourth option – Pic

Use this selection 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 merely desire to copy the text from your data (no formatting at all). The cell values will be separated by tab spaces and each row will exist in a separate paragraph.

Method two. How to Embed An Excel Chart In PowerPoint

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

2. In PowerPoint, right-click on the slide where you desire to add together the Excel chart OR become to Abode > Paste > Paste Special. You will so see 5 icons similar y'all see in the screenshot below in Paste Options:

Icons you volition run across if you're copying Charts from Excel

First option – Use Destination Theme & Embed Workbook

Use this choice if you want your chart to employ your PowerPoint file's theme and formatting. This allows your chart to blend in nicely with the residuum of your slides.

Second choice – Keep Source Formatting & Embed Workbook

Utilise this option if y'all desire to use your Excel file's formatting. This means that the chart volition look exactly the same in PowerPoint and Excel.

Third pick – Use Destination Theme And Link Data

Employ this choice to use your PowerPoint file's formatting and go along the chart linked to the original Excel file.

4th option – Go on Source Formatting And Link Data

Use this option to use your Excel file's formatting and proceed the nautical chart linked to the original Excel file.

Fifth choice – Picture

Use this selection to paste your Excel chart as a motion-picture show. You can't edit the chart just you can supersede it with another image and apply pic formatting.

Final Words On Embedding and Linking An Excel File In PowerPoint

Every bit I have shown in this tutorial, there are quite a number of means to share and present your Excel file in PowerPoint. Just retrieve the principal differences betwixt linking and embedding content from Excel to PowerPoint. You will have to make up one's mind for yourself which of these options are all-time used in your specific state of affairs.

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

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