External Links Don't Update When Using Certain Functions
 

I have noticed that formulas containing MATCH, INDEX functions which
reference external spreadsheets do not update unless the source is
open. This doesn't seem to be the case with VLOOKUP though.

Has anyone else found this? Know why it happens? Know anyway round
it?

Regards

Ben


--
blatham
------------------------------------------------------------------------
blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441
View this thread: http://www.excelforum.com/showthread...hreadid=530390

External Links Don't Update When Using Certain Functions
 

Is it a simple =index(match()) formula?

Or do you use other functions in your formula.

=indirect(), =sumif(), =countif() (for example) won't work with closed
workbooks.



blatham wrote:

I have noticed that formulas containing MATCH, INDEX functions which
reference external spreadsheets do not update unless the source is
open. This doesn't seem to be the case with VLOOKUP though.

Has anyone else found this? Know why it happens? Know anyway round
it?

Regards

Ben

--
blatham
------------------------------------------------------------------------
blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441
View this thread: http://www.excelforum.com/showthread...hreadid=530390

--

Dave Peterson