Translations:Faq/Calc/016/3/en
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")