I am attempting to use a SUMIF formula that uses a criteria range and sum
range in another file. The formula works fine as long as both files. When
the second file is closed the formula returns "#Value".

Is there a way to get it to return the last known data until the link is
updated without having to have both files open.

I am running 2007 and the formula reads =SUMIF('filepath[filename]sheet
name'!$A$13:$A$23,"CR", 'file path[file name]sheet name'!$S$13:$W$23)

Thanks in advance