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.
'file:/FilePath'#SheetName.DataRange
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.
When the source data has been changed, to update the reference
data accordingly, do the following steps:
- Click from the main menu.
- In the Edit Links window, click Update.