How to add hyperlinks in shared Excel workbooks

How to add hyperlinks in shared workbooks?

Problem: Me and my colleague are working with a shared workbook and we want to add some hyperlinks but the hyperlinks button is disabled! What can we do ?


For some security reason Microsoft has decided to disable the Hyperlinks button in shared workbooks. This can quite annoying when we are sharing a one time task with a colleague and we need to insert hyperlinks. So what can we do ?

The solution is to use the Excel  function: HYPERLINK(link_location, [friendly_name])

Example: =HYPERLINK("http://www.google.com", "This is a link to Google.com")


More information about disabled features in excel when a workbook is shared can be found in this article: Allowing multiple users to edit a workbook simultaneously - Disabled Features


Do you like this free website? Please share this page on Google+ or Facebook.