INDIRECT.EXT FUNCTION

K

Kaby

This formula:

=INDIRECT.EXT('H:\["&D100&".xls]BUYERSREQUEST'!C44)

keeps giving me a #value error...any obvious reasons....
 
P

PeterAtherton

Kaby

The indirect function requires the other workbook to be open. You might be
better creating links between the books. If you can open both books together
enter = then point to C44 on the buyersrequest sheet and press enter.

Regards
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDIRECT.EXT 3
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Indirect.ext 1
INDIRECT function 1
Using cell contents in a formula to refer to another file 11
INDIRECT.EXT reference 1
Indirect.EXT download dosn't exist 3
INDIRECT.EXT 3

Top