Linking data from another workbook using AVERAGEIF

[darknightxv]

[FONT=&quot]Hi everyone,[/FONT]
[FONT=&quot]I am using an averageif equation, and in the equation I am referencing data from another workbook on my company's server. When I have said workbook open, the equation works and I get my number. However, if I close it, I get a #value ! error. Is there anyway to fix this error and have the equation work when the referenced workbook is closed?[/FONT]
[FONT=&quot]Thank you for the help in advance!![/FONT]