Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, and 2016. 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: Hyperlinks in Shared Workbooks.
by Allen Wyatt
(last updated July 2, 2018)
Dan has a shared workbook into which he needs to insert a hyperlink. However, as long as the workbook is shared, the hyperlink features in Excel are not available. Dan wonders if there is a way to insert hyperlinks into shared workbooks.
The short answer is no, there is not. When you choose to share a workbook, some options in Excel are simply not available anymore; inserting hyperlinks is one of those options that is removed once the workbook is shared.
If you absolutely must add the hyperlink to the workbook, the only option is to un-share the workbook, add the hyperlink, and then again share the workbook. You'll no longer be able to add any more hyperlinks, but the one you added while the workbook was unshared will work just fine.
There is one caveat in taking this approach to adding the hyperlink—you need to be careful that you don't un-share the workbook if you have the Track Changes feature of Excel turned on. In the process of un-sharing the workbook, Excel will turn off the tracking and discard the change history. If this is important to you, the only option is to make sure that you add the hyperlinks before sharing the workbook and first turning on Track Changes.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (11058) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Hyperlinks in Shared Workbooks.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
When you enter a URL or e-mail address in a worksheet, Excel usually converts it to a clickable hyperlink. This doesn't ...Discover More
Is your worksheet information destined for a Web page? Here's how you can specify the fonts that should be used when ...Discover More
Creating a drop-down list with Excel's data validation feature can be a nice touch for a worksheet. What if you want the ...Discover More
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.