External Links Don't Update When Using Certain Functions

[blatham]

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

 

[Dave Peterson]

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.