Hyperlinks not working

ssblue
ssblue used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
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
ssblueCoordinator

Author

Commented:
Thanks for the help. Sorry I missed you. See you next time.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial