In this article, I will show you how to link an MS Word document to Excel worksheets. Often, while working in Excel, you may need to link information from a Microsoft Word document to an Excel sheet. Depending on your requirement, there is more than one method available to link MS Word files to Excel. So, I will show you those ways. Besides, I will explain how to embed a Word document in Excel.
Difference Between Embedding and Linking a Word Document
Before starting to link and embed Word documents to Excel, let’s have a look at the difference between embedding and linking a document.
➤ Linking an MS Word file to an Excel worksheet means the original Word document and the Word file placed in the Excel sheet will maintain a connection. If I say more elaborately if you edit/delete anything from the original Word document, that change will automatically reflect in the Word file that is placed in the Excel file. And, it happens vice versa.
➤ On the other hand, Embedding a Word document in an Excel worksheet will break the connection between the Word files instantaneously. That means if you update the original Word file, that change would not reflect in the Word file embedded in the Excel sheet. One thing to remember about embedding files to Excel is: ‘It increases the size of the Excel file’.
Link Word Document to Excel: 2 Easy Methods
1. Link Word Document to an Excel Worksheet Using ‘Object’ Option
Now I will link a Word document to Excel using the Object option.
- Go to the Excel worksheet where you want to create the linkage. I have put my cursor on Cell B4.
- From Excel Ribbon, go to the Insert tab.
- Next, go to Text > Object.
- As a result, the Object window will show up. Now click on the Create from File By clicking on the Browse option choose the Word document you want to link with. After that put tick marks on Link to file and Display as icon option (see the screenshot). Click OK.
- Finally, the Word file is placed on the Excel sheet and the file is linked to the original Word file.
You can link a Word document very easily by using a Hyperlink. For example, I have a file name typed in Cell B4. Now, I will link a Word file to this file name.
- Click on Cell B4, and press Ctrl + K from the keyboard to bring the Insert Hyperlink.
- Click on the Existing File or Web Page option and choose the Word document from the Look in Press OK.
- Consequently, Cell B4 is linked to a specific Word document. Clicking the Hyperlink will direct you to the corresponding MS Word file.
- You can open the Insert Hyperlink window just by right-clicking on the specified cell.
- Or, you can go Inset > Link > Insert Link to bring the window.
Read More: How to Import Data from Word to Excel
Apply Object Option to Embed Word Document in Excel
This time I will show you how to embed an MS Word document into an Excel file.
- First, go to the corresponding Excel sheet.
- Then go to Insert > Text > Object.
- The Object window will show up. Next, go to Create from File Then, click on the Browse option to choose the Word document you want to link with. Put tick marks on only the Display as icon option (see the screenshot) and select OK.
- As a consequence, the Word file will be embedded in the Excel file.
Pros and Cons of Linking Word Document to Excel
Linking Word documents to Excel has some amazing advantages such as:
- Linking Word files keeps your Excel file size less. This is because the information is still stored in Word files, Excel only displays the information.
- In case you need to update anything in Word files, linking saves a lot of time.
Unfortunately, there is a disadvantage of linking Word files to Excel.
- The file path must be always the same which means the original Word file requires to be in the same location. If you send the Excel file to people who do not have the access to the linked location, then linking won’t be useful.
Download Practice Workbook
You can download the practice workbook that we have used to prepare this article.
In the above article, I have tried to discuss several methods to link a Word document to Excel elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.