How to Link a Word Document to Excel (2 Easy Methods)

Apply the Object Option to Embed a Word Document in Excel

• First, navigate to the Excel sheet where you want to embed the Word document.
• Go to the Insert tab in the Excel Ribbon. In the Text group, click on Object.
• The Object window will appear. Select the Create from File tab.
• Click the Browse button to locate the Word document you want to embed. Make sure the Link to file option is unchecked.
• You can choose to display the embedded document as an icon or show the first page of the document directly. To display it as an icon, check the Display as icon option (see the screenshot). If you decide to display the icon, you can also click the Change Icon button to select a different icon and provide a meaningful caption.

• Click OK. The Word document will now be embedded within the Excel file.

Remember that embedding Word documents can be useful for adding detailed text below an Excel table or providing documentation about a process.

Pros and Cons of Linking Word Document to Excel

Pros:

• Reduced Excel File Size: When you link a Word document to an Excel worksheet, the information remains stored in the Word file, and Excel only displays it. As a result, your Excel file size remains smaller compared to embedding the entire Word document.
• Time-Saving Updates: If you need to make changes to the content within the Word document, linking allows you to update it directly. Any modifications made in the original Word file will automatically reflect in the linked Word file within Excel.

Cons:

• Fixed File Path: The main disadvantage of linking Word files to Excel is that the file path must always remain the same. In other words, the original Word document needs to be in the same location. If you share the Excel file with others who don’t have access to the linked location, the linking won’t be useful for them. Remember that embedding a Word document in Excel breaks the connection between the files, but it increases the size of the Excel file.

Download Practice Workbook

You can download the practice workbook from here:

Related Articles

• How to Convert Word to Excel but Keep Formatting
• Copy from Word to Excel into Multiple Cells
• How to Convert Word to Excel with Columns
• How to Convert Word Table to Excel Spreadsheet

Hosne Ara is a materials and metallurgical engineer who loves exploring Excel and VBA programming. To her, programming is like a time-saving superhero for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B. Sc. in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, she's shifted gears and now works as a content developer. In this role, she. Read Full Bio

Dear Hosne, This disadvantage is killing me and it took me forever to finally figure out this is the problem I was having. “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.” This sort of defeats the purpose of using the same linked cell format for numerous analogous projects. I think I have a workaround for my own use as a real estate appraiser. I set up spreadsheets for different projects that are identically formatted to my linked spreadsheet. For example “Year Built” is in cell B1, “Square Footage, in cell B2, “Date of Appraisal” is in cell B3 on the linked spreadsheet and on every property spreadsheet. When I am ready to do my final linking, I simply copy the cells over whatever data is already existing in my linked spreadsheet. They key is I am copying data, not copying files. I still have my original data properly formatted in its appropriate job folder, I can work on other projects, within their own folders, and not lose the data for a prior project that I might still be working. I also did see that someone wrote a macro that changes the file path within the link codes so that the paired Word and Excel files are properly linked if
moved or copied to a new folder. The macros changes the coding to become relative rather than the links continually referring back to the original source file.