Translations:Faq/Calc/016/3/en

    From The Document Foundation Wiki

    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")