INDIRECT() makes my head hurt...

X

xrbbaker

I can pull in a value from another spreadsheet with this:

='T:\Operations\IT\IT Shared\IT Process Engineering\Resource
Allocation\PM\[PM Data Entry.xls]CDH BLUECHOICE'!$M$194

If I copy the above (minus the =) and paste it in cell AB3, then why doesn't

INDIRECT(AB3) pull the same value? Instead it returns #REF.

I think I understand the concept of INDIRECT(), but I get gummed up every
time I try to use it with LINKED files. Any help appreciated.

Thanks,

Russ
 
D

Dave Peterson

=indirect() won't work when the sending file is closed--as you've seen.

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

That includes =indirect.ext() that may help you.
I can pull in a value from another spreadsheet with this:

='T:\Operations\IT\IT Shared\IT Process Engineering\Resource
Allocation\PM\[PM Data Entry.xls]CDH BLUECHOICE'!$M$194

If I copy the above (minus the =) and paste it in cell AB3, then why doesn't

INDIRECT(AB3) pull the same value? Instead it returns #REF.

I think I understand the concept of INDIRECT(), but I get gummed up every
time I try to use it with LINKED files. Any help appreciated.

Thanks,

Russ
Click to expand...
 
X

xrbbaker

Aaarrrrgggh. The more I learn, the more I realize how little I know.
Thanks. I'll check out the Add in.

Russ



Dave Peterson said:
=indirect() won't work when the sending file is closed--as you've seen.

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

That includes =indirect.ext() that may help you.
I can pull in a value from another spreadsheet with this:

='T:\Operations\IT\IT Shared\IT Process Engineering\Resource
Allocation\PM\[PM Data Entry.xls]CDH BLUECHOICE'!$M$194

If I copy the above (minus the =) and paste it in cell AB3, then why doesn't

INDIRECT(AB3) pull the same value? Instead it returns #REF.

I think I understand the concept of INDIRECT(), but I get gummed up every
time I try to use it with LINKED files. Any help appreciated.

Thanks,

Russ
Click to expand...
Click to expand...
 
Top