This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

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)

Example: =DDE(soffice;c:\myfile.sxi;MySheet.A1)

Documentation / User FAQ / Calc / Previous-Next