Insert an Excel worksheet into a Word doc
Posted on June 1, 2009 at 5:56 am
Ever need to insert an Excel worksheet into a Word document and have them linked so that when you update the main Excel worksheet, it automatically updates the one in the Word document?
There are actually two ways to insert an Excel object into Word, linking and embedding. When you embed an Excel worksheet, the worksheet will not be updated when you update the main Excel file.
When you insert a linked worksheet, whenever you open the Word file, the linked Excel sheet will update it’s values to match the main external Excel file.
In this article, I will show you how to do it using both methods.
Insert Excel Worksheet into Word – Linking
There are actually two ways to insert and link an Excel worksheet in Word. You can either copy and paste or go to Insert on the ribbon and choose Object.
Step 1: Select the area in your Excel spreadsheet that you want to include in Word and then press Ctrl + C to copy the contents.
Step 2: Now go to your Word document and press Ctrl + V to paste the contents into the Word file. In order to link, you have to click on the Paste Options button at the bottom right and choose Match Destination Table Style and Link to Excel.
Step 3: That’s it, now your table will be linked to the original Excel file. Whenever you update the Excel file and reopen Word, it will ask you if you want to update the doc with the data from the linked files.
Step 4: Click Yes and your table will reflect the new values. If you have both files open at the same time, you’ll see the changes live.
The second way to link an Excel spreadsheet to Word is by using the Insert menu.
Step 1: In Word 2007, click on the Insert ribbon and choose Object.
Step 2: Click on the Create from File tab and click on the Browse button to choose your file.
Step 3: Once you choose the file, you will see two check boxes at the right side. If you want to link the Excel spreadsheet, you need to check Link to file. If you want to embed the Excel spreadsheet, don’t check it.
That’s it! This does the same thing as the first method I described. Like I said, if you want to embed the worksheet, just don’t check the box. Enjoy!
» Filed Under MS Office Tips
Related Posts
- Dynamically Link an Excel Spreadsheet into a Word 2010 Document
- Insert Different Types of Hyperlinks into an Excel Spreadsheet
- Link Cells Between Tabs and Workbooks and In Excel 2010
- Link to specific slides in other PowerPoint presentations
- Create and Use a Table of Contents In Word 2007 – 2010
Excellent tip.
Very useful.
Thanks
How do you make copies of the document? do you have to copy both files? should both files be in the same directory
Does this work only for the first worksheet? What if you needed to link to the 2nd worksheet in the workbook?
What if the embedded object (spreadsheet) is larger than 1 page?
This is very interesting! I needed to attach an Excel spreadsheet to a Word doc and ended up using a link inside the Word document. However, embedding the Excel sheet directly into the Word doc is even better! Thanks!
What if the linked spreadsheet is larger than 1 page and I need it to continue with table headings to the next page as if the page had not ended?
When you choose the Insert method to insert the Excel file into Word, does it automatically insert the first sheet only? How can you get it to insert a different sheet?
Really a great article! Thank you for the Excel and MS Office tips. I am always learning something new.
I just can’t wait to use it. Great tips.