External Cells

Resolver One can retrieve values from other spreadsheet files. This works for:

  • Microsoft Excel files
  • Resolver One workbooks

External cells in formulae

Reference the cell like this:

='[external.rsl]Sheet1'!A1

This looks in external.rsl for Sheet1, and returns the value from A1.

The path

You can specify the path in two ways:

Relative
Relative to the position of the workbook. Both workbooks have to be saved before this works.
Absolute
Give a full path to the external file, e.g. ='[C:\path\to\external.rsl]Sheet1'!A1.

External cells in user code

Use the GetExternalCell function to return the value of a cell in another workbook. For more complete documentation, see the entry in the API Documentation.

Comments