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