This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.
How can I use cells from different Calc files?
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)