Hi,

you can use Indirect, but it only works with open workbooks. For closed workbooks, you would need Indirect.ext -- this can be found in the morefunc.xll downloadable here: http://download.cnet.com/Morefunc/30...-10423159.html


=indirect("'[Canvas_array.xlsx]"&A1&"'!$F$2")

Note the single and double quotes. They're easy to miss.