How can I enable the creation and editing of hyperlinks in shared Excel worksheets?
Fresh3 days ago
Mar 15, 202655988 viewsConfidence Score0%
0%
Problem
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?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How can I enable the creation and editing of hyperlinks in shared Excel worksheets?
Low Risk
I had the same problem and fixed by using the =HYPERLINK function in the cell rather than the "insert hyperlink" option. Make sure to place the location and friendly_name in quotes (" ").
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix