How to Open Embedded File in Excel (with Useful Steps)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for how to open an embedded file  in Excel, then you are in the right place. We need to use an embedded file for different purposes while using Excel. In this article, we’ll try to discuss how to open an embedded file in Excel.


Download Practice Workbook


Steps to Open Embedded File in Excel

Excel offers easy ways to open an embedded file in Excel. We just need to follow some simple steps.


1. Opening a New Workbook

To open an embedded file we need a platform where we can open it. As our task is to open it in an Excel File, so we need an Excel file before doing anything. Again, an Excel file has lots of cells. But we have to open the embedded file in one specific file.
So, firstly, open a new workbook like this.

how to open embedded file in excel

Here, we have stated the title and hidden the gridlines for a better look, you may or may not choose to do the similar.

Read More: How to Insert an Excel File into Another Excel File


2. Working with Insert Feature

In this step, firstly, select a cell where we want to open the embedded file. In this case, it is B4.
Secondly, go to Insert > select Text > choose Object.

Working with Insert Feature

Here, we have selected the Text option because the file has a name which is in text format. And under the Text option, we have selected Object because the embedded file acts like an object in a cell.

Read More: [Fixed!] Cannot Insert Object in Excel


3. Browsing an Existing File

In this step, we need to browse the file which we want to embed. This file needs to be on your PC. After choosing Object, eventually, a window named Object will appear.
Then, go to Create from File > select Browse.

Browsing an Existing File

Secondly, select the file from the specified location and click Insert.

how to open embedded file in excel

Thirdly, make sure that Link to File and Display as Icon are selected. Link to File needs to be selected because we want the embedded file to be linked to its original location. And if we select Display as Icon the embedded file will remain as an icon in the selected cell.
Lastly, click OK.

how to open embedded file in excel

Consequently, the embedded file will be like this.

Now, whenever you want to open that file just click on the icon, and it will appear in front of you.

Read More: How to Attach Documents in Excel (3 Suitable Ways)


How to Open Embedded PDF in Excel

Similar to an Excel file, we can also open an embedded PDF file easily in Excel. The procedure is pretty much identical to what we have just seen in the earlier section.

Steps:
Firstly, open a new worksheet.

How to Open Embedded PDF in Excel

Secondly, select cell B4.
Thirdly, select Insert > choose Text > pick Object.

how to open embedded file in excel

Immediately, an Object window will appear.
Thirdly, go to Create from File > select Browse.

Now, select the PDF file from the specified location > click Insert.

Again, make sure that Link to File and Display as Icon are selected.
Lastly, click OK.

how to open embedded file in excel

Finally, we will have the embedded PDF file like this.

how to open embedded file in excel

Read More: How to Attach PDF File in Excel (3 Easy Ways)


Conclusion

That’s all about today’s session. And these are the ways to open an embedded file in Excel. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section and explore our website ExcelDemy, a one-stop Excel solution provider.


Related Articles

Shajratul Alam Towhid
Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo