Faq/Calc/016

How to retrieve the content of cells originating from other files
You can:
 * 1) open the source file;
 * 2) select and copy the desired cell(s) to the clipboard with ;
 * 3) open the target file;
 * 4) choose the target cell;
 * 5) Go to
 * 6) Select the Paste option.

Or you can do this more directly by writing the following formula directly into the formula bar or into the target cell: =DDE("soffice";"YourFilePath";"SourceFileName.SourceCellName") For example : =DDE("soffice";"C:\My Documents\LibreOffice\MyFile.ods";"Sheet.A1")