Spreadsheet hyperlink to tab

[Toon]

Hello! I have a huge spreadsheet with many tabs. Jn the first tab there is table of contents with hyperlinks formulas for each tab:

=HYPERLINK("#"&"‘Tab Name’!A1"; “Tab Title”)

On click it redirects me to the certain tab in the same document. It works fine in MS Excel 2013, but LibreOffice send me alert:

LibreOffice could not find a web
browser on your system. Please check
your Desktop Preferences or install a
web browser (for example, Firefox) in
the default location requested during
the browser installation.

What’s wrong? How to fix this problem?

[mariosv]

I think the issue is the separator between sheet name and address “!”,

First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula options/Formula syntax → Excel A1.

Or with formulas like:

a) =HYPERLINK("#"&MID(CELL(“address”;‘Tab Title’.A1);2;99);“Tab Title”)

b) =HYPERLINK("#"&ADDRESS(1;1;1;1;"‘Tab Title’");“Tab Title”)