software

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: www.excelforum.com/member.php...oamp;userid=32434
View this thread: www.excelforum.com/showthread...hreadid=541508See

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

xcell05.free.fr/english/ (look for INDIRECT.EXT)--
Kind regards,

Niek Otten

quot;starguyquot; gt; 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: www.excelforum.com/member.php...oamp;userid=32434
| View this thread: 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(quot;'quot;amp;A3amp;quot;\[quot;amp;B3amp;quot;.xls]quot;amp;C3amp;quot;'!quot;amp;quot;B5quot;)or=pull(quot;'quot;amp;A3amp;quot;\[quot;amp;B3amp;quot;.xls]quot;amp;C3amp;quot;'!B5quot;)--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;starguyquot; gt; wrote in
message ...
gt;
gt; I have used INDIRECT function which has reference to other workbook.
gt; when I close other book which I have referenced to. INDIRECT function
gt; do not update values, instead it gives error.
gt;
gt; is there any other function for the same working which would update
gt; values even when other file is closed.
gt;
gt;
gt; --
gt; starguy
gt; ------------------------------------------------------------------------
gt; starguy's Profile:
www.excelforum.com/member.php...oamp;userid=32434
gt; View this thread: www.excelforum.com/showthread...hreadid=541508
gt;

thanks for reply.
is there not any built in substitute for this problem?--
starguy
------------------------------------------------------------------------
starguy's Profile: www.excelforum.com/member.php...oamp;userid=32434
View this thread: www.excelforum.com/showthread...hreadid=541508If there was it would not be necessary for Harlan to write one.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;starguyquot; gt; wrote in
message ...
gt;
gt; thanks for reply.
gt; is there not any built in substitute for this problem?
gt;
gt;
gt; --
gt; starguy
gt; ------------------------------------------------------------------------
gt; starguy's Profile:
www.excelforum.com/member.php...oamp;userid=32434
gt; View this thread: www.excelforum.com/showthread...hreadid=541508
gt;