The function you'd want to use that's built into excel is =indirect(). But that
function returns an error if the sending workbook is closed.

Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/

That includes =indirect.ext() that may help you.

Libby wrote:

I have the following formula to try and link to a cell in another workbook
but want to reference a new cell each day. I am getting a # ref. Can
somebody help with this please.

=INDIRECT("'"&$A$44&"'[mar MIR.xls]mid-city'!$g$39")
--
Libby

--

Dave Peterson