Documentation / User FAQ / Calc / Previous-Next
You can open the source file, select and copy onto the clipboard (CTRL + C) the desired cells and then in the target file you should select a target cell and choose Edit > Paste Special from the Menu Bar and enable the link option in the choice shown in the dialog box that opens.
A more direct way to do this is to write a formula of the following
kind in the formula bar or in a target cell:
=DDE(soffice; YourFilePath; SourceSheetName.SourceCellName)
Example: =DDE(soffice;c:\myfile.sxi;MySheet.A1)
Documentation / User FAQ / Calc / Previous-Next