Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
One of the cool things you can do in Word is link to other files that will call objects or even embed those objects right in your Word document. Now an object could be an Excel worksheet or a PowerPoint slide or slideshow or any other destination file that supports OLE, that is object linking and embedding. So you might be asking yourself, why not just copy the object like the PowerPoint slide show and then paste it into my Word document? Well, that will work, but when you insert your presentation as an object, you can actually use PowerPoint commands to work with the slideshow right in word.
Even better when you link to the object. It does actually reside in your Word document, it appears in your document, but it actually resides on its own, separated from the Word document with only a link to it. This makes it dynamic, not static, meaning changes made to the source file they'll appear in the Word document because they're linked. Let's try both linking and embedding. We'll link an Excel worksheet and embed a PowerPoint presentation in a Word document that's already been created for you. So let's go up to our Office button and down to Open.
We'll need to navigate to the lesson 18 folder of your exercise files to find newsletter 18D. Give that a click and then Open. So here's our two-page newsletter and as we scroll down you can see at the bottom of page 2 might be good spot for us to put our company balance sheet, but not enough room. So I'm going to click down here, that gets my cursor flashing, and hold down Control and press Enter simultaneously on the keyboard. Control + Enter is the keyboard shortcut for inserting a page break.
So now I'm flashing away here on page 3 of 3, that's were I want my balance sheet to show up. Now you can easily insert an object and browse to that file to go find it. We'll do that first but you'll see that if we just insert an object, we don't have any control over what shows up. Here's what I mean. We'll go up to Insert on the ribbon over to the right here and click the Object drop-down. You see there's two choices, Object and Text From File, we do want to insert an object so give it a click. There's two tabs. Now we can create this new object from scratch and you see the different types including Microsoft Excel, or we can create this from an existing file, which is what we want to do.
We want to go find that file. So we'll click Create from File and then Browse. Again we're going a want to browse to the lesson 18 folder of your exercise files because that's where will find ECP balance sheet 1. Give that a click and then Insert. Now it's not inserted quite yet, we have to decide how. If we don't select a Link to File, we'll be actually embedding it in our document. The other option is just to display it a little icon representing the file that we can double click to go into that file in the native application.
But I do want a link to the file, so I'll click that check box and then OK. So it's busy thinking here, it's looking for that spreadsheet, that worksheet and then boom! Inserts it right here into my document. So you can see it just inserted the entire worksheet. I had no options or no way to say how much of it I wanted to show up here. So there is another route we can take if you want a little more control over what shows up in your Word document. So let's just go up to our Undo button and undo that and try a different route.
This is going to involve opening up Excel 2000 so if you've got it installed we're to launch it and open up that worksheet. So go down to the Office button and we'll find a Microsoft Office Excel 2007, I see it here. You may have to go to All Programs, and then go to the Microsoft Office folder and then click it and then there you'll find Microsoft Office Excel. That launches the application. Now let's go open that worksheet. We'll go to the Office button here and Open and we'll need to navigate or lesson 18 folder.
So navigate to that folder of your exercise files and find ECP balance sheet 1. So we'll open that up. Now this is what we saw when we just linked to it in our Word document but let's say we only want a show this portion of it here. The blue parts. We can select that, I'm going to cell A1 right here and I'm going to click and drag across and down all way down to Total assets and stop right there. So I'm going to act like I'm about to copy and paste this but I'm not actually to just go in and paste it like we're used to.
I'll go up to my Copy button. Give it a click. I know it's been copied, I see the marching ants around the perimeter, and I'll switch back to my Word document. So this is where I want to kind of paste it but I want to paste it as an object, not just what I copied. So I want this to be dynamic, that means I go up to my Home tab here. And I click the Paste drop-down button and choose Paste Special. This allows me to paste it as an actual object, and I'm going to paste the link first of all.
And it's not HTML, it's a Microsoft Office Excel worksheet. There we go. when I click OK, look what gets inserted into my Word document. Just what I had selected. So two different ways to link to an object. So this looks much better now. There are some things you need to know. When the worksheet is updated or changed in Excel, you will see the results in Word and I'm going to show you how to do that momentarily. also when you open this file from this point forward, you'll see that it gets updated with the latest data, you'll be prompted to accept that.
You can also do this manually at any time too. So let's update our worksheet to see this in action. We're going to go back to Microsoft Excel, and let's go up here where we've got our cache number for 2006 sitting at $400,000. Let's change that to $500 ,000 dollars, and Enter. Alright, so we switch back to our Word document over here. This, if we click on it, will get selected. You can see that it's actually an object that we linked to, it's not actual data.
So the next thing we'll do now is go up to our Office button. We'll go down to Prepare and you'll see Edit Links to Files. We'll give that a click to open up this dialogue here. So currently it's still showing as 400,000 but when I update now, it gets updated to the 500,000. This dialog box stays open, because I do want to show you a couple of options here too. Notice here that we've got automatic updates selected. We've also got the opportunity to choose manual, which means we have to decide when we want to update this and if we don't want any updates, we can actually just lock it.
So there will be no updates to this actual link that we see here in our Word document. We'll just turn that off and set it back to automatic and click OK. All right, now we can also make it so that this info that you see in Word never gets updated again by locking it, and that covers linking to another file, but what about embedding one? And as I promised we're going to embed a PowerPoint slide show.
So let's scroll down further, we'll click down here and insert another new page by holding down Control and pressing Enter. Control + Enter creates a new page page, page 4, that has nothing on it. We're going to go up to our Insert tab and again we're going to select Object and gives that a click. It is a file. It already exists, so Create from File, and we'll browse to the lesson 18 folder and here's our PowerPoint presentation called introducing ECP. We'll give that a click and then Insert.
Now this time we're not going to link and we're not going to display it as an icon, we're just going to embed it right in our document. When we click OK, it takes a moment, because it's taking the entire slideshow now and it's going to embed it in our Word document. The advantage to embedding again is that we can actually you run this slide show from within our Word document. So here it is, we see the first slide, we know it's an object when we click on it and look what happens when we double click on it. It starts to launch the actual slideshow. So that means we can start clicking on slides to move from one slide to the next.
We're just going to move through this entire slideshow. You can press Enter on the keyboard. Tools and Cookware, here we go. Look at this stuff. Courses, and there we are at the end of the slideshow now. When I click to exit, I'm brought back to my Word document. So if I'd just pasted this the old- fashioned way, I wouldn't actually be able to use all these PowerPoint controls and view the actual slideshow inside of Word. Alright so we've worked with linking and embedding objects that were actually other Microsoft Office files.
One was our Excel worksheet, and this one is a PowerPoint slide show, but you can do this with other formats, like a PDF for example. When we bring in a PDF file, it appears as an icon that can be accessed by double-clicking it. So we'll moved down to the bottom again of our Word document here, hold down Control and press Enter and we're now onto a fifth page. It's empty and let's insert our PDF file now object. So again we'll go up to Insert if you need to, click Object. And it's going to be from a file that exists already, so we click the tab and then Browse.
And we're going to go and find our PDF file, here it is, newsletter 18.pdf and when we click Insert, we're now going to click OK and look what happens. Just the icon shows up. So if I wanted to do this PDF I have to double click it and of course you'll want to launch or at least have the free Adobe Acrobat program loaded on your computer to view it. I'm going to cancel this and then click to deselect. And next we'll explore inspecting a document for hidden metadata.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74476 Viewers
80 Video lessons · 129699 Viewers
52 Video lessons · 63942 Viewers
59 Video lessons · 49724 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.