INDIRECT function do not work when other file is closed

[starguy]

I have used INDIRECT function which has reference to other workbook.
when I close other book which I have referenced to. INDIRECT function
do not update values, instead it gives error.

is there any other function for the same working which would update
values even when other file is closed.

 

[Niek Otten]

See

ftp://members.aol.com/hrlngrv/ (look for pull.zip

http://xcell05.free.fr/english/ (look for INDIRECT.EXT)


--
Kind regards,

Niek Otten

|
| I have used INDIRECT function which has reference to other workbook.
| when I close other book which I have referenced to. INDIRECT function
| do not update values, instead it gives error.
|
| is there any other function for the same working which would update
| values even when other file is closed.
|
|
| --
| starguy
| ------------------------------------------------------------------------
| starguy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32434
| View this thread: http://www.excelforum.com/showthread.php?threadid=541508
|

 

[Bob Phillips]

You could try Harlan Grove's PULL function. You can get it
ftp://members.aol.com/hrlngrv/ (look for pull.zip)

You would use it like so
=pull("'"&A3&"\["&B3&".xls]"&C3&"'!"&"B5")


or


=pull("'"&A3&"\["&B3&".xls]"&C3&"'!B5")


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[starguy]

thanks for reply.
is there not any built in substitute for this problem?

 

[Bob Phillips]

If there was it would not be necessary for Harlan to write one.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)