Excel Insert Hyperlink does not put full path

I have an Excel spreadsheet located in a folder on a network drive. I want to include hyperlinks to images. These are in a sub-folder. If I insert the hyperlinks in the spreadsheet cell, these are added with relative path. Because of this if I email the sheet the hyperlinks are broken for the reader.

On the other hand if I copy the file somewhere else and insert hyperlinks as they were before in that original sub-folder, these hyperlinks are added with absolute path. They work in the email.

How can I tell Excel to always put the absolute path for hyperlinks?

Here is an image of what the Insert Hyperlink dialog looks like when the link works in email. Note how Excel puts the full path.

Here is an image of the dialog when the hyperlink is broken when accessed in an email message.

The file is the same but in the first image I copied the file to a folder on the computer before inserting the link. In the first image the file is on the same network drive as the file that I link to.

It looks like Excel only puts the full path if the inserted link is on another drive or directory structure.

I haven't tried the Hyperlink function. But since someone will be using the sheet, I want to stick to the Insert Hyperlink feature if possible.