Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. 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.

Hyperlinks in Shared Workbooks

by Allen Wyatt
(last updated January 12, 2019)

4

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, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Hyperlinks in Shared Workbooks.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Independent Radio Buttons

Radio buttons are great for some data collection purposes. They may not be that great for some purposes, however, for the ...

Discover More

Modifying Error Alerts Received

Excel helpfully lets you know when the data or formulas you've entered in a cell don't make sense. It does this by ...

Discover More

Dividing the Screen Unevenly between Two Workbooks

When working with multiple workbooks, you'll typically want to resize the workbook windows so you can see the data from ...

Discover More

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!

More ExcelTips (ribbon)

Links to Hyperlinks

Hyperlinks in a worksheet can be helpful or essential, depending on the nature of your data. If you create a link to a ...

Discover More

Extracting Hyperlink Information

In Excel, a hyperlink consists of two parts: the text displayed for the link and the target of the link. You can use a ...

Discover More

Adding Excel Information to a Web Page

Besides saving a worksheet as a complete Web page, you can also save smaller portions of your data to an existing Web ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is nine more than 3?

2019-01-17 10:51:40

Gary

I have a workbook that is saved in SharePoint, and shared with our whole team. We have no problem adding hyperlinks to it, so I'm not sure I understand what is being discussed here.

Thank you!


2019-01-16 01:46:16

Hisham Saifudeen

I store the files that need to be accessible by everyone in OneDrive and copy paste the link of that file in the shared Excel workbook.

Works fine.


2019-01-15 15:13:33

J. Woolley

@Roy: You might be interested in my SuperLink function described here:
http://dailydoseofexcel.com/archives/2018/07/02/hyperlink-formula-events/#comment-1045646


2019-01-14 20:08:33

Roy

To have hyperlinks that can change over time without unsharing:

BEFORE sharing, write a macro that will take a text writing of the desired hyperlink and act upon it as if it were an actual hyperlink. Macros added before sharing are always available to run. Since text can obviously be added any time, one can add new "hyperlinks" without a need to unshare and re-share.

Of course, to add it to an existing shared workbook, one would have to navigate the rocks and schoals described in Mr. Wyatt's answer.


This Site

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.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.