Hi,

I'd appreciate some help or an answer on this one.

I've created a remote reference to another workbook to bring in the date
from a financial period calendar.

I.e. ='c:\[sample.xls]Sheet1'A1

I've enabled the 'update remote references' option in the tools, options
menu but the reference doesn't update unless the target workbook is
currently open.

Is this something that I can resolve or just a quirk of ExcelXP.

Please let me know.

Many thanks, Darren.