Sumifs used referencing a closed workbook

I get the #Value if I try to use the Sumifs formula referencing a closed workbook. I put {} around it and that makes it work, but if I want to update the values I can't unless that referenced workbook is open - otherwise it is #value error even with the {} (array brackets).
I read that sumproduct might be able to help. can you help me with this?
My current sumifs formuls is the following:

{=SUMIFS('[Period Marketing Costs Master Worksheet Q115 - February.xlsx]Database_actuals'!$K:$K,'[Period Marketing Costs Master Worksheet Q115 - February.xlsx]Database_actuals'!$A:$A,$C$8,'[Period Marketing Costs Master Worksheet Q115 - February.xlsx]Database_actuals'!$G:$G,F20)}

Thank you!

Did you try to enable auto updates in the excel options>>trust center>trust center settings>>enable auto update for all workbook links?