Insert or Embed Excel File In Word, Excel Or PowerPoint Presentation - As Object

Today in this article I will discuss with you how to Embed Excel (as Object) in office tools, like Microsoft Word, Microsoft PowerPoint and in Microsoft Excel itself.

What is Embedding ?

Excel Object Linking and Embedding - Object Linking and Embedding (or OLE for short) is a technique used to insert data from one programme into another.

So what do I mean to say by 'Excel as Embedded Object' ?

This questions may arise in your mind, to understand what is 'Excel as Embedded Object' suppose you are in a meeting where you need to give a speech about your opinion or performance with the supportive data. The two things you required

1.   Power Point Presentation and

2.   Excel workbook with data

Now in an ongoing discussion/meeting, if your data in Excel need to display then you must minimize PowerPoint presentation and then you have to find out the specific folder where your excel is stored and then you open it to display the data.

Now, in another situation let suppose you need to email your presentation with the supporting Excel file you have to attach two files (*.ppt or *.xls).

Or suppose you need to update the Excel data and to be displayed in PowerPoint presentation then also you have to update and copy the data then paste this data in PowerPoint slide.

Using embedded object you can shorten this process and can accomplish the task in seconds.

Embed is a process where we insert a file or data from one application to another application, e.g., attach or insert an Excel file or data in PowerPoint presentation or Word file or in Excel.

You may think that you can put a link and that will also do the same job, i.e., it will also refer to the file too.

You are right but in Embedding, if you update your excel file it will easily change the data in the PowerPoint presentation.

Let us learn how to insert Excel in PowerPoint presentation and Microsoft Word.

Excel Workbook Embedded in Microsoft Word

How to insert Excel in Excel ?

Steps :

1.   On the Insert tab, in the Text group, click Object.

Object Menu in Excel

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

Select from File

3.   Click Browse, and in the Browse dialog box, browse to and then select the Excel workbook that contains the Excel file that you want to insert, and then click OK.

Select from File - Display as icon

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

Embedded Excel Displaying as icon

Save this workbook.

Now whenever you double click on this ICON, it will open this workbook.

Note : The important thing to be noticed is that whenever you send this or share this Excel workbook, the attached or inserted Excel will also be shared.

How to insert or Embed Excel in Microsoft Word ?

Steps :

Same Steps to be followed,

1.   On the Insert tab, in the Text group, click Object.

Object Menu in Word

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

Select from File - MS Word

3.   Click Browse, and in the Browse dialog box, browse to and then select the Excel workbook that contains the Excel file that you want to insert, and then click OK.

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

Excel file Embedded in MS Word

How to insert or Embed Excel in Microsoft PowerPoint ?

Steps :

Steps are same,

1.   On the Insert tab, in the Text group, click Object.

Object Menu in PowerPoint Presentation

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

Select from file - PowerPoint Presentation

3.   Click Browse, and in the Browse dialog box, browse to and then select the Excel workbook that contains the Excel file that you want to insert, and then click OK.

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

Excel file embedded in PowerPoint Presentation

You might noticed that the process is same to embed Excel file (it can be any file, pdf, text etc.) in any office tool.

You might also noticed that I always used the option 'Display as icon' not the other option 'Link' or 'Link to a file'.

Let us understand what will happen if we use the 'Link' option.

Embed Excel in PowerPoint using Link to file.

I have done all the steps mentioned above and embedded the Excel file as Linked in PowerPoint and it is displayed as below.

Excel file embedded as LINK in PowerPoint Presentation

Link Excel file to PowerPoint Presentation

The existing table in the excel is displayed as 'table' in PowerPoint presentation, another noticeable thing is that if you double click this table this will activate the Excel and now if you update this table it will be updated in PowerPoint presentation also. (I am using Office 2007 so it will open the Excel workbook but in Office 2013 and after 2013) you can edit the table inside the PowerPoint presentation)

Link Excel file to Microsoft Word

The whole table will be embedded in the word file as 'Table' and you can also edit the excel inside the MS Word file. Please follow the below picture.

Excel file embedded in Word as LINK

Link Excel file to Excel

The Excel table will be displays as OBJECT in excel file. Please follow the below picture.

Excel file embedded in Excel as LINK

Hope you have enjoyed ... Please comment if you have any question or doubts in your mind...

Keep reading & Sharing

Stay blessed ...