Hi

I have a sumif formula which links to another external file. Problem is whenever I close the file #value error shows up. Is there a way to avoid that.

Formula is [=SUMIF('S:\2 Logistics Ops\[Shipping Report.xlsx]2017 Outpatient Claim'!$F:$F,C1,'S:\2 Logistics Ops\[Shipping Report.xlsx]2017 Outpatient Claim'!$D:$D)]