Ask Your Question
0

How to turnoff security for hyperlinks in spreadsheet [closed]

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

terrykhatri531 gravatar image

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

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

Comments

which kind of Hyperlink do you talking about?

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

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

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

1 Answer

Sort by » oldest newest most voted
0

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

karolus gravatar image

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

Hallo
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.

Karolus

edit flag offensive delete link more

Comments

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 +0100 )edit

Question Tools

1 follower

Stats

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

Seen: 248 times

Last updated: Jul 30 '14