How to Link an Excel File to a Word Document
How to Link an Excel File to a Word Document
Need to reference an Excel chart, table, or data set in your Word document? You can easily add a quick link to any Excel file in a Word document, or even embed the file within the document to avoid the possibility broken links. This wikiHow article will teach you how to create a quick link to any Excel file in your Microsoft Word document.
Steps

Open your Word document. You can either open it from Word by going to File > Open or you can right-click the .doc(x) file and select Open with > Word.

Click the Insert tab. It's in the editing ribbon above your document. On Mac, this tab is along the top of your screen instead.

Click Object and Object. It's in the Text grouping and will open an Object Dialog Box.

Click the Create from File tab. It's at the top of the window.

Click Browse. Your file manager (File Explorer for Windows and Finder for Mac) will open so you can look for your Excel file.

Double-click to select your Excel file. Alternatively, you can single-click the file to select it, then click Open/OK to choose it.

Check the box next to "Link to file" and click OK. This will create a link to your file that others can click to view the Excel data. Clicking the link will open the Excel data at its original location. If you'd rather embed the Excel file within your Word document, check the box next to "Display as an icon" and click OK. If you have a chart or table from Excel that you'd like to insert in your Word document, copy the chart in Excel (Ctrl + C (Windows) or Cmd + C (Mac)) and paste it into Word (Ctrl + V (Windows) or Cmd + V (Mac)). Update the chart in Word after you've changed it in Excel by clicking the chart in Word, then going to Chart Design/Chart Tools Design > Data > Refresh.

What's your reaction?

Comments

https://hapka.info/assets/images/user-avatar-s.jpg

0 comment

Write the first comment for this!