External cells

Resolver One can retrieve values that are stored in other spreadsheet files. This works for both Excel files and other Resolver One workbooks. For example, the following formula entered into a cell will populate the cell with the value that is at A2 on Sheet1 in external.rsl: ='[external.rsl]Sheet1'!A2

The path to the external workbook in the above example is relative to the current workbook i.e. the workbook that loads the external value and the workbook that contains the value are in the same directory. It is, therefore, necessary for both workbooks to be saved before the formula will work. It is also possible to specify a full path to the external file: ='[C:\path\to\external.rsl]Sheet1'!A2