INDIRECT() makes my head hurt...

[Guest]

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

 

[ed]

Russ,

Try putting INDIRECT into the other file and then linking to the
INDIRECT function.

Regards,
Eddie
http://HelpExcel.com
1-888-MY-ETHER ext. 01781474

 

[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

 

[Guest]

Ed,

Sorry - I'm not following you. How would I do that?

thx

 

[Guest]

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

Russ

=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