Do you know how to tie Excel and Word files together?
Applying MS Word and Excel, you can link files together by embedding them. Embedding an Excel document or file in a Word file means that you can see the Excel spreadsheet in the Word file, and any changes that you make to the Excel document will appear in the Word file.. The same is true for Word files linked to Excel files.
Now, please follow the instructions below to learn how to tie information in a Word document and an Excel document together.
Add Excel Spreadsheet in Word document
1 、Run your Word file and the select “Insert” from the menu bar, then “Object.”
2 、Please choose “Excel sheet” from the dialogue box that opens, and then click on the “Select File” button at the bottom of the dialogue box.
3 、Please select the Excel spreadsheet which you like to add and click “Insert.”
4 、In order to edit the Excel file, double-click on it in the Word file. This will open the Excel file in a separate window. Make your edits and save both documents to save your work. The edits you made in the Excel document will show in your Word file.
Add Word document in Excel Spreadsheet
5 、Please run your Excel spreadsheet and then select “Insert” from the menu bar, and then “Object.”
6 、Please choose “Word document” from the dialogue box that opens, and then click on the “Select File” button at the bottom of the dialogue box.
7 、Please select the Word file which you like to insert and click “Insert.”
8 、In order to edit the Word file, double-click on it in the Excel file, in the same way described above. Save your work in both documents when done. In additon, the edits which you made in the Word file will show as well in your Excel spreadsheet.