Referencing data from other spreadsheets

You can reference data from other spreadsheets and update it.

1. In your current spreadsheet, select the cell to add the reference.
2. On the Formula toolbar, click the Function icon.
3. In the Formula Input Line, enter the code in the following format:
   FilePathSheetNameDataRange
   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.
4. Press  ↵ Enter .