Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. 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: Changing Links.
by Allen Wyatt
(last updated September 19, 2016)
You already know that Excel allows you to establish links between your workbook and other objects, such as graphics, Word documents, and other items. (We're talking regular links here, not hyperlinks.) There may come a time when you wish to change the links. For instance, you may have a picture linked in your workbook, and you want to change the location of the picture (to a different directory or drive). Excel allows you to change your link so it can point to the proper file as the source of the object in the workbook.
To change links in this manner, follow these steps:
Figure 1. The Edit Links dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (7364) applies to Microsoft Excel 2007 and 2010. You can find a version of this tip for the older menu interface of Excel here: Changing Links.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
If you work with multiple workbooks at the same time, you might wonder how to tie them together so they open and close and ...Discover More
If you need to combine the contents of a bunch of workbooks into a single workbook, the process can get tedious. Here's a ...Discover More
As you work with a workbook over time, it is possible for the workbook to grow to a huge size. If you want to shrink the size ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
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.