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

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

The workbook is open when I am using the function.
--
Libby


"Dave Peterson" wrote:

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

What's in A44?

Why not just:
=INDIRECT("'[mar MIR.xls]mid-city'!$g$39")

or drop the =indirect() completely
='[mar MIR.xls]mid-city'!$g$39

Libby wrote:

The workbook is open when I am using the function.
--
Libby

"Dave Peterson" wrote:

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


--

Dave Peterson