PDA

View Full Version : Help: How to keep indirect() function unupdate value...



yurble_vn
08-24-2007, 12:20 AM
Hi all,

I use the address + indirect() function in calculation, but whenever I turn off the source file that indirect() function refer to, it returns #Ref.

is there anyway to force Indirect() not to update value at start up?

Thanks

Bob Phillips
08-24-2007, 12:45 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")

As for alternatives, try the INDIRECT.EXT function in Laurent Longre's
MOREFUNC.XLL add-in, available from