Sending a worksheet with hyperlinks

[KMJ]

Worksheet contains hyperlinks to various word documents. However, once I
email the hyperlinks no longer work. I put all the info together on a shared
network drive. What do I need to do in order for the hyperlinks to work?

 

[Barb Reinhardt]

I've had hyperlinks change in Excel because of a setting in Options.

Tools -> Options -> General -> Web Options -> Files -> Update links on save
needs to be unchecked.

I wonder if the person you send this to has it checked and when they open
and save the workbook, the links are updated.

I'm sure there could be other reasons, but that's the one I've been fighting
lately. In addition, I've turned this off, only to find it back on again
days later and I know it's an EXCEL option and none of my macros turn it on.

HTH,
Barb Reinhardt