I have a worksheet that is pulling data from another sheet saved, but i get values unless i actually have the other sheet pulled up. Here is a function that does that.

=SUMIF([April12SA_PATH_EXT.xls]SA_PATH_EXT!$P$11:$P$1000,$C6,[April12SA_PATH_EXT.xls]SA_PATH_EXT!$F$11:$F$1000)

Anyone have an idea to fix this?

Thanks