Ask Your Question

How to turnoff security for hyperlinks in spreadsheet [closed]

asked 2014-07-30 16:23:52 +0200

terrykhatri531 gravatar image

updated 2016-03-01 16:41:55 +0200

Alex Kemp gravatar image

Hi, Will appreciate you can find me a way to execute hyperlinks in excel/spreadshett, as when I click on a hyperlink I get LibreOffice warning saying "For security reasons the hyperlink cannot be executed. The stated address will not be opened". I have already unchecked "Ctrl-click required to follow hyperlinks" in the options menu for security.

I am using LibreOffice 3.

Many Thanks

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-03-01 16:42:05.097837


which kind of Hyperlink do you talking about?

karolus gravatar imagekarolus ( 2014-07-30 16:36:46 +0200 )edit

I have created links in spreadsheet that point to another worksheet cell

terrykhatri531 gravatar imageterrykhatri531 ( 2014-07-30 16:40:58 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-07-30 17:21:54 +0200

karolus gravatar image

updated 2014-07-30 17:22:29 +0200

Example for Hyperlink to Target in same Document:
=HYPERLINK("#sheet3.A99";"click me")

and for Target in another Dokument:
=HYPERLINK("file:///path/to/other.ods#sheet1.A1";"click me")

second Arguments click me is optional.


edit flag offensive delete link more


Hi Karolus, I created the link as you suggested but its giving me the same security warning. I want to turn off the warning some how - tks

terrykhatri531 gravatar imageterrykhatri531 ( 2014-07-31 04:06:47 +0200 )edit

Question Tools

1 follower


Asked: 2014-07-30 16:23:52 +0200

Seen: 251 times

Last updated: Jul 30 '14