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?