Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Inserting Video into Worksheets.
Written by Allen Wyatt (last updated July 1, 2023)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021
Excel allows you to add more to your workbooks than just numbers or text. You can also add all sorts of other objects. For instance, you can add simple graphics, pictures, or even videos. How you add graphics and pictures has been covered in other ExcelTips. Adding video is a horse of a different color, however.
Why is adding video different? The primary reason is because videos can be so huge. Consider the normal way to add objects:
Figure 1. The Create from File tab of the Object dialog box.
Did you notice that the Object dialog box had a check box that controlled whether the video would be linked or not? The default is for the video not to be linked, which means it will be embedded. Videos are notoriously huge, and the size of that video (however many megabytes or gigabytes it is) is added to your workbook when the video is embedded. This makes the workbook much harder to distribute to others.
You might think that the size issue can be solved by not embedding and, instead, linking to the video. While this does solve some issues, it raises others. When the video is linked, only the path to the file is stored in the document, but it is a fully qualified path. This means that, even if both documents are in the same directory, the directory name becomes part of the link. If you move both files or send them to someone else who stores them on their system, the link is automatically broken.
Another thing to keep in mind—regardless of whether you link or embed—is that if you share your workbook with others, they need to have a video player capable of playing the video you've added to the workbook.
A totally different approach is to simply hyperlink to your videos. You can either upload the videos to a video sharing service (such as YouTube) or you can put them on a local drive. Either way, a hyperlink is easy to add to your worksheet. Assuming that the video is something that can be played by your Web browser, the hyperlink could be a good route to go.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6868) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021. You can find a version of this tip for the older menu interface of Excel here: Inserting Video into Worksheets.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
The camera tool allows you to capture dynamic "pictures" of portions of a worksheet. If you want to use the camera tool ...
Discover MoreIf you want an image to appear more than once in a worksheet, there are a few ways you can approach the issue. This tip ...
Discover MoreIf you need to arrange a group of graphics so that they are evenly distributed between a starting point and an ending ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2024 Sharon Parq Associates, Inc.
Comments