How come when I copy and paste special 'values' the following concatenated
string,

="='H:\Test\[" & D150 & ".xls]BUYERS REQUEST'!$C$44"

I get

='H:\Test\[PRDtemplate_Rev9.2_8-11-06-TEST.xls]BUYERS REQUEST'!$C$44.

I would actually like excel to automatically recognize that it is a formula,
and return the linked value (i.e. $8.75) and not the actual formula. Is
there a way to do this without going into the cell and hitting enter to get
the desired value.