Created attachment 113235 [details] spreadsheet examples An external data reference in an ods sheet: ='file:///home/peter/tmp/dir_a/src.ods'#$Tabelle1.A1 is changed to: ='file:///home/peter/tmp/dir_a/home/peter/tmp/dir_a/src.ods'#$Tabelle1.A1 ^^^^^^^^^^^^^^^^^^^^^ when the file is saved in MS Excel 2003 (xls) format and then re-opened again. Each subsequent save/open is adding another extra string like this: ='file:///home/peter/tmp/dir_a/home/peter/tmp/dir_a/home/peter/tmp/dir_a/src.ods'#$Tabelle1.A1
Hi @PeterP, thanks for reporting. I think this is a duplicate of: https://bugs.documentfoundation.org/show_bug.cgi?id=48463 As workaround you can put the path in a cell and use the INDIRECT() function (or put directly as text in the function) to compose the address properly, in this way nothing is changed when saving the file. e.g. B10: ="'file:///Users/me/Users/me/file.ods'#Sheet1." c10: =INDIRECT(B10&cell("address";A1)) *** This bug has been marked as a duplicate of bug 48463 ***