Ask Your Question
0

Can't Use Relative Path for Hyperlink in Calc [closed]

asked 2014-06-25 23:54:31 +0200

Travis Gibby gravatar image

updated 2014-06-26 00:03:56 +0200

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-26 09:41:16.410650

2 Answers

Sort by » oldest newest most voted
0

answered 2014-06-26 02:17:08 +0200

m.a.riosv gravatar image

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.

edit flag offensive delete link more

Comments

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.

Travis Gibby gravatar imageTravis Gibby ( 2014-06-26 02:43:23 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-06-25 23:54:31 +0200

Seen: 2,593 times

Last updated: Jun 26 '14