[SOLVED (Excel req. Calc non-default cell reference in hyperlink)] - Excel unable to handle LibreCalc created/modified hyperlinks

When I modify and add hyperlinks in some xlsx sheets with Calc, Excel will be unable to resolve the hyperlink, popping it’s error message.

I found this topic on OO OO Hyperlinks are not working in Excel (View topic) • Apache OpenOffice Community Forum
Unfortunately the solution by Villeroy does not say what magic is applied to make the hyperlink compatible across applications. example: CalcHyperlink.xlsx ExcelHyperlink.xlsx
The hyperlink formatting looks the same to me.

Does anyone know what method to use?

Care to provide a working example file created by Excel and the same not working one (i.e. one link added) saved by LibreOffice? Edit your question to attach files with the paperclip.

The difference is that in CalcHyperlink.xlsx the hyperlink is #Sheet2 stored as

<hyperlink ref="B3" location="Sheet2" display="Sheet2"/>

while in ExcelHyperlink.xlsx it is #Sheet2.A1 stored as

<hyperlink ref="B3" location="Sheet2!A1" display="Sheet2"/>

Apparently Excel can’t cope with a sheet-only fragment and needs a cell reference included.

Thank you, that seems to be the case.

Please, if the answer solves the question click :heavy_check_mark:.