Relative hyperlink to a file vs absolute

[exceldemon]

I have some files I would like to create a hyperlink to.

For example:

(network drive)

S:\Myfiles\Project1\excelfile.xls
S:\Myfiles\Project1\PDF\4223.PDF

Normally you would just create a link to the PDF files, S:\Myfiles\Project1\PDF\4223.PDF.

Sometimes the Project1 folder is moved, breaking the link to the PDF file.

Example:

S:\Myfiles\Project1\

moved to

S:\CompletedMyFiles\Project1

Is there a way to link to the PDF relative to the folder?

\PDF\4223.PDF