Hyperlinks not working

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

Do more with

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


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