Hyperlinks not working

Hyperlinks are not working for some websites that I copied and pasted into excel - some are.

Need help figuring out why and how to fix them.

The ones in yellow are working but the rest are not working.
Hyperlinks.xlsx
ssblueAsked:
Who is Participating?
 
ShumsConnect With a Mentor Distinguished Expert - 2017Commented:
Hi Sue,

Sharing Workbook disables several features in Excel Hyperlink, the only option to unshare 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 workbook was unshared will just work fine.

Other option would be to insert function next to Web Link's cells, =HYPERLINK(link_location, [friendly_name])

Check in attached in Col E
ssblue_Hyperlinks.xlsx
1
 
ssblueAuthor Commented:
Thanks for the help. Sorry I missed you. See you next time.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.