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