In the formulas and functions of the current document, you can refer to data from one or more external documents.
The following restrictions apply in this version of the application:
–The current and external documents must be saved in .xlsx, .ods or .xods format.
–The current and external documents must be local, that is, they must be located directly on your computer.
–The creation of references to cells and cell ranges of an external document is supported. The use of structured references, as well as references to cell names and ranges, is not allowed.
–The reference that is entered manually into the cell with the name must be absolute. When creating a data source for a named range, you need to enter an absolute reference for correct functioning.
You can create a reference to data from an external document in one of the following ways:
–Open an external document and select the desired cell or range of cells with a mouse click.
–Enter the reference manually without opening an external document.