Solving problems caused by embedding; Issue #263 June 12, 2012

Presentation Tip: Solving problems caused by embedding

Many presenters don’t realize that PowerPoint embeds or links to other files or information in ways that can cause problems. They may have experienced a PowerPoint file that has grown too large to e-mail to someone else, or linked files or videos don’t work when they take their presentation to another computer to present. In this article I want to explain how you can fix four of the most common embedding issues I see when dealing with PowerPoint presentations.

Why is embedding such an issue? Because in almost all cases, there is no way the presenter knows about the restrictions or problems until after they have occurred. PowerPoint doesn’t give you warnings or notices to let you know that something won’t work the way you expect it to. You have to find out the hard way.

One of the most common issues is your PowerPoint file growing very large after you add some photos. They could be photos of people or objects, but they make your PowerPoint file so large you can’t e-mail it. What is going on? When you insert a picture on to a slide, PowerPoint embeds the entire picture file into the PowerPoint file. And that is the problem. Many photos are much higher resolution than PowerPoint will ever need. Instead of only keeping the pixels it will use, PowerPoint stores all the pixels in the picture. This makes your PowerPoint file much larger than it needs to be. To solve this issue, there are two possible solutions; both involve removing the pixels you won’t use, resulting in a great looking picture that is much smaller in size. The first solution is one you use before you insert the picture into your presentation. Use a program such as the Microsoft Office Picture Manager (usually found in the Office Tools folder on your computer) to resample or resize the photo to a more reasonable size. Usually a standard size of 1024 x 768 will be sufficient to use a photo full screen without any distortion. The second solution is to use the Compress feature within PowerPoint for those photos you have already inserted on to slides. This tool does a good job and you don’t have to take all the photos out of your presentation and start again. This is one of the many tips on using photos that I shared in a webinar earlier this year.

Another embedding problem that most presenters don’t know about is unknowingly exposing confidential data in spreadsheets. One of the methods for copying a table of information from Excel to a PowerPoint slide is to use the Copy Special, Excel Worksheet Object option. This method allows you to resize the table on the slide making it easy for everyone to see. What it doesn’t tell you is that it embeds the entire Excel worksheet, all the tabs and all the information, into your PowerPoint file. Besides making your PowerPoint file bigger, it allows anyone who opens the file to access your entire worksheet. All they need to do is double click on the inserted object and it opens the full Excel worksheet on the slide. They can navigate to any tab and see any information in that worksheet. When I showed this to a client last year, the President was mortified to find out they had been sending confidential data to clients without knowing it. Instead of using the Excel Worksheet Object paste method, use one of the methods that does not embed the worksheet in your PowerPoint file. I covered five methods for inserting Excel data into PowerPoint in my webinar on using financial data in a presentation.

A third embedding issue, one that is also hidden from presenters is using a video in a presentation in PowerPoint 2007 and earlier versions (I’ll get to the issue about videos in PowerPoint 2010 next). In the versions of PowerPoint that most of us use, when you insert a video, it doesn’t actually insert the video file into your PowerPoint file. It just uses a link to the video file that it accesses during the presentation. The issue here is when you move the presentation to another computer. That link stops working in many cases. Why? Because the link is pointing to the specific folder on the original computer, which isn’t on this computer. To solve this problem, make sure that the video file is in the same folder as the PowerPoint file before you insert it on a slide. That way, PowerPoint only needs to remember the file name, not the whole folder structure. Then, make sure you move all the files – PowerPoint and video files – to the new computer. The problem will almost always be gone. I covered many more topics on using video in your PowerPoint presentation in this webinar.

In PowerPoint 2010, they rewrote the way that video files are treated, partially in order to solve the above issue. But they introduced another issue. In PowerPoint 2010, when you insert a video on a slide, it embeds the entire video file into your PowerPoint file. If you thought you have seen some large PowerPoint files with images, wait until you see the size of some of these files. Some of them are too big to even be put on a CD! You can try to compress the video, but often that will reduce the quality of the video, which isn’t what you want for your audience. An alternative is to use a hyperlink to the video file instead of embedding it into the slide. The hyperlink will use the media player on your computer to play the video. It is a little more awkward as a presenter, but it may be what you need to solve the issue of outrageously large PowerPoint files due to embedded videos in version 2010.

As a presenter, you need to be aware of what PowerPoint is doing behind the scenes and how it can affect your ability to deliver an effective presentation. Use these tips to help avoid problems caused by how PowerPoint embeds different objects in your presentation.