IBM Lotus Symphony


Referencing data from other spreadsheets

You can reference data from other spreadsheets and update it.

To reference a cell value in another spreadsheet, do the following steps:
  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.
    '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.
  4. Press Enter.
When the source data has been changed, to update the reference data accordingly, do the following steps:
  1. Click Edit > Links from the main menu.
  2. In the Edit Links window, click Update.

Product Feedback | Additional Documentation | Trademarks