I have a simple sumif formula that for both the Range and Sum_Range link
to other another file. However, unless the linked to files are open i
get a #Value! error message. Unlike most linked formulas this doesnt
just hold the latest value.

Any ideas how i can get around this?


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=514339