Hyperlink formula not working due to "security"?

[yeevy]

I've just started using excel to organize my music library. In one of the columns I have a list of hyperlinks each leading to a different cell in another worksheet. However, while it works just fine with the Cmd + K (I'm on Mac) keyboard shortcut, it simply doesn't work when I use this formula:

=HYPERLINK('Commenti e link relativi'!B2; "1")
("'Commenti e link relativi'" is the name of a worksheet)

Anyway, when I run the formula, it will arbitrarily edit the formatting of the cell to look like a hyperlink, but will remain completely inert when clicked on.
I have to make several hundreds hyperlinks, so using Cmd + K for each one of them is not really an aoption.

 

[yeevy]

I've just started using excel to organize my music library. In one of the columns I have a list of hyperlinks each leading to a different cell in another worksheet. However, while it works just fine with the Cmd + K (I'm on Mac) keyboard shortcut, it simply doesn't work when I use this formula:

=HYPERLINK('Commenti e link relativi'!B2; "1")
("'Commenti e link relativi'" is the name of a worksheet)

Anyway, when I run the formula, it will arbitrarily edit the formatting of the cell to look like a hyperlink, but will remain completely inert when clicked on.
I have to make several hundreds hyperlinks, so using Cmd + K for each one of them is not really an aoption.

I forgot to add, in other cases, it will instead activate the hyperlink but give me an alert telling me that the source of the link might not be safe. If I then tell it to continue anyways, it will simply tell me that it cannot be opened, without telling me anything else.

 

[Fluff]

Hi & welcome to MrExcel.
Try

=HYPERLINK("#'Commenti e link relativi'!B2"; "1")

 

[yeevy]

Hi & welcome to MrExcel.
Try

=HYPERLINK("#'Commenti e link relativi'!B2"; "1")

Thanks! That works, but may I ask you what adding the # and " " does exactly?

 

[Fluff]

You need to pass the address as a string hence the quotes. The # is need when linking to a cell in the same workbook.