Can't Use Relative Path for Hyperlink in Calc

So I’m trying to link to a wav file that is in the same folder as my spreadsheet. I entered this into the input line:
=HYPERLINK(“111scr00010004201.wav”,“Immediate No”)

But when I click the link, get this error message:

“111scr00010004201.wav” is not an absolute URL that can be passed to an external application to open it.

I don’t want it to be an absolute URL I want it to be a relative URL.

I tried this…
=HYPERLINK(“file://111scr00010004201.wav”,“Immediate No”)
This time I got this message:

Windows cannot find ‘\111scr00010004201.wav’. Check the spelling and try again, or try searching for the item by clicking the Start button and then clicking Search.

Isn’t there a way to reference a file’s location relative to the folder that my document is saved in?

I’ve also tried making sure that these options were checked:
Tools>Options>Load/Save>General>Save URLs relative to file system
Tools>Options>Load/Save>General>Save URLs relative to internet

But that didn’t seem to make a difference either.

I think you must enter the all path and set up the option for relative URL, and do a test. Even the all path is showed only the relative is saved and used.

Thanks, I just tried this though. I set those options to relative and then I tested it by moving the spreadsheet and sound file to a new folder. It still didn’t work. It was looking for the sound file in it’s old location.