You can use INDIRECT, but it requires Workbook B to be open. Sort of
this solution you will need VBA.

=INDIRECT("'[Workbook B]Sheet1'!A1")

This will be updated as soon as Workbook B opens.

HTH
Kostis Vezerides


Glynn Taylor wrote:
I have an array in 'Workbook B'

'Workbook A' contains a cell, say A1, in which I've Calculated a variable
cell reference

How can I obtain the value held in the un-open 'Workbook B' from the cell
defined in 'Workbook A' A1?

Thank you