INDIRECT function do not work when other file is closed

**starguy** · 05-12-2006, 07:20 AM

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 · 05-12-2006, 07:40 AM

See

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

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

--
Kind regards,

Niek Otten

"starguy" <[email protected]> wrote in message
news:[email protected]...
|
| 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
|

Bob Phillips · 05-12-2006, 07:40 AM

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

**starguy** · 05-12-2006, 08:10 AM

thanks for reply.
is there not any built in substitute for this problem?
I have read about other function or combination of functions to solve this problem but I have not remembered where I read about this.
do you know? Please provide me with link of that web.

Bob Phillips · 05-12-2006, 02:00 PM

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>