Difference between revisions of "Referencing data from other spreadsheets"
From Apache OpenOffice Wiki
(Created page with "<div class="body refbody"><p class="shortdesc">You can reference data from other spreadsheets and update it.</p> <div class="section"><div class="p">To reference a cell value in …") |
(+cat) |
||
| Line 14: | Line 14: | ||
</div> | </div> | ||
</div> | </div> | ||
| + | |||
| + | [[Category:Documentation]] | ||
| + | [[Category:Calc]] | ||
Latest revision as of 15:41, 23 September 2013
You can reference data from other spreadsheets and update it.
To reference a cell value in another spreadsheet, do the
following steps:
- In your current spreadsheet, select the cell to add the reference.
- On the Formula toolbar, click the Function icon.
- In the Formula Input Line, enter the code
in the following format.
<code>'file:/<strong class="ph b"><var class="keyword varname">FilePath</var></strong>'#<strong class="ph b"><var class="keyword varname">SheetName</var></strong>.<strong class="ph b"><var class="keyword varname">DataRange</var></strong></code>
For example, to reference A1:B5 in the example.ods file
under the c:/temp/ directory, enter 'file:/c:/temp/example.ods'#Sheet1.A1:B5. - Press Enter.
