You cannot use hyperlinks to switch between worksheets, you have to use the tabs generated by SpreadsheetConverter to switch sheet.
If you want to link to another web page, use absolute links, i.e.
and not just
The http + domain names is necessary.
Just download, install and test the Excel add-on now. Or let us convert a spreadsheet for you, for free.