| <meta http-equiv="REFRESH" content="10;url=http://wiki.services.openoffice.org/wiki/Documentation/FAQ"> |
| <h3>This page is outdated. You will be redirected to <a href="http://wiki.services.openoffice.org/wiki/Documentation/FAQ">http://wiki.services.openoffice.org |
| /wiki/Documentation/FAQ</a> shortly.</h3> |
| <div style="margin-bottom: 10em;"></div> |
| <p><a href="../../index.html">Documentation</a> / <a |
| href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a |
| href="015.html" accesskey="p">Previous</a>-<a href="017.html" |
| accesskey="n">Next</a></p> |
| <h3>How can I use cells from different Calc files?</h3> |
| <p>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 <b>Edit > Paste Special</b> from |
| the Menu Bar and enable the link option in the choice shown in the |
| dialog box that opens.</p> |
| <p>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: <br> |
| <b>=DDE(soffice; YourFilePath; SourceSheetName.SourceCellName)</b></p> |
| <p><b> Example:</b> =DDE(soffice;c:\myfile.sxi;MySheet.A1) </p> |
| <p><a href="../../index.html">Documentation</a> / <a |
| href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a |
| href="015.html" accesskey="p">Previous</a>-<a href="017.html" |
| accesskey="n">Next</a></p> |