I have created six files, all with LibreOffice CALC
The first two files contain source information
* a file labeled "Source ods file", filed in ods format
* a file labeled "Source xls file, filed in xls format
Then I created four files that link to these source files.
* Two files are in ods format, one linking to the xls-format source file, the other linking to the ods-format source file.
* Two files are in xls format, one linking tot he xls-format source file, the other linking to the ods-format source file.
When the two ods-format link files are opened and the links are updated, the numbers appear directly copied from the source file.
When the two xls-format link files are opened and the links are updates, the numbers do not copy correcly and you only get REF#
In my earlier comments I noted that the link files in xls format do not copy the sheet name
I have created six files, all with LibreOffice CALC
The first two files contain source information
* a file labeled "Source ods file", filed in ods format
* a file labeled "Source xls file, filed in xls format
Then I created four files that link to these source files.
* Two files are in ods format, one linking to the xls-format source file, the other linking to the ods-format source file.
* Two files are in xls format, one linking tot he xls-format source file, the other linking to the ods-format source file.
When the two ods-format link files are opened and the links are updated, the numbers appear directly copied from the source file.
When the two xls-format link files are opened and the links are updates, the numbers do not copy correcly and you only get REF#
In my earlier comments I noted that the link files in xls format do not copy the sheet name
I hope this helps illustrate the problem