up vote 1 down vote favorite
share [g+] share [fb]

I have hyperlinks in some Excel 2010 (both .xlsx and .xls formats) worksheets. If I enable sharing of the workbook I can no longer edit or create hyperlinks - the options no longer exist on the menu and/or are greyed out.

How can I fix and/or workaround this?

link|improve this question
81% accept rate
feedback

2 Answers

up vote 2 down vote accepted

I had the same problem and fixed by using the =HYPERLINK function in the cell rather than the "insert hyperlink" option.

HYPERLINK(link_location, [friendly_name])

Make sure to place the location and friendly_name in quotes (" ").

link|improve this answer
feedback
up vote 2 down vote

Sharing a workbook disables several features in Excel.Hyperlinks, merged cells, charts, pictures and more. If the workbook is shared, you will not be able to use these features. If you un-share the workbook, these items should be availble again. This has been the case for a long time. This Excel 2003 article shows this, and this Excel 2010 article also shows this.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.