Created attachment 195732 [details] Example documents for use of Table from external sheet In Excel it is possible to use a link to a Table in an external sheet in a structured-reference. You can use e.g. [1]!myData[#All]. (You do not write the [1] manually, but it is automatically constructed by Excel when you create the link.) myData is the name of the Table in the external sheet. [1] refers to the file externalLinks1.xml in folder externalLinks. The file externalLinks1.xml contains an element <externalBook r:id="rId1"> (or other rId number). The accomplishing externalLink1.xml.rels file in the _rels folder on same level has the path to the external sheet. I have attached a zip-file which contains such an example. Excel currently shows the values only if the external sheet is open. When LibreOffice imports such file it cannot display the data, even if the external file is opened. Even if "update external links" is disabled or you open the file read-only, it does not show the content of the cells, although the <c> elements contain the value at time of saving. For ods-files exist same mechanism to use a Database Range from an external ods-file. In menu Sheet > External File browse to the external file. Then you can select the Database Range from the external file. Update of the values is done with menu Edit > Links to external files. However, ods has no means for structured-references; that is bug 162088. Request minimum: If "update external links" is disabled or the file is opened read-only, the cell values as stored in the file should be shown. Request full: Make LibreOffice able to handle a Table in external file in structured-references for xlsx-files.
Reproducible. Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: f7197e574cdbd7410fcadab1632bcce2626dca5a CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Seems Excel need the source files opened for update properly at opening.