INDIRECT() makes my head hurt...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

xrbbaker - 09 Mar 2007 14:50 GMT

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

Reply to this Message

ed@HelpExcel.com - 09 Mar 2007 14:56 GMT

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

Reply to this Message

xrbbaker - 09 Mar 2007 15:07 GMT

Ed,

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

thx

> Russ,
>
[quoted text clipped - 5 lines]
> http://HelpExcel.com
> 1-888-MY-ETHER ext. 01781474

Reply to this Message

Dave Peterson - 09 Mar 2007 15:06 GMT

=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:
>
[quoted text clipped - 11 lines]
>
> Russ

Signature

Dave Peterson

Reply to this Message

xrbbaker - 09 Mar 2007 15:21 GMT

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.
>
[quoted text clipped - 18 lines]
> >
> > Russ

Reply to this Message