that will always reference the value from the closed workbook in that cell. however, if something else feeds into the closed workbook, that closed workbook will not updarte itself until it is opened.

so, whenwever you open the workbook that references the closed workbook, the last saved value from the closed workbook will be shown