INDIRECT.EXT FUNCTION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This formula:

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

keeps giving me a #value error...any obvious reasons....
 
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
 
You must log in or register to reply here.

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 help 0
INDIRECT function 1
Indirect.ext 1
Runtime Error 203 0
INDIRECT.EXT reference 1
Using cell contents in a formula to refer to another file 11

Back
Top