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...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=541508

See

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

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


--
Kind regards,

Niek Otten

"starguy" wrote in message
...
|
| 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...o&userid=32434
| View this thread: http://www.excelforum.com/showthread...hreadid=541508
|

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" wrote in
message ...

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...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=541508

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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=541508

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"starguy" wrote in
message ...

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


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=541508