Excel object hyperlinks not migrating to Openoffice

[CruelCoin]

Hi guys,

Wondering if you could help me with a specific issue i'm having.

I have an excel catalog with a main menu, linked to around 20 sub-sheets.

Because my users are not tech savvy (horticulture) i want to avoid using macros, to get around the enabling macros/trust issue and the ensuing 20 phone calls every time i send the list around.

So to avoid that problem I settled with inserting objects for the buttons on the menu and hyperlinking them to the sheet I want, by using the "Place in This Document" option in the hyperlink menu.

That all works fine in excel, but doesn't work in OpenOffice.

TL;DR / My question - How can i hyperlink an object to a specific sheet in an excel workbook, using a written address (or any other method) and have it work in both excel and openoffice.
Pictures below for what i'm trying to do.

Any advice much appreciated!

ScreenHunter_31 May. 24 12.39.jpg
ScreenHunter_32 May. 24 12.40.jpg

[6StringJazzer]

Welcome to the Forum CruelCoin !

I'm sorry to say that pictures are useless for this type of question. Hyperlinks are not tricky but it might be helpful to attach your actual Excel file. Under the text box where you type your reply click the Go Advanced button. Then scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.