Hi All,

looking for a resolution - I don't know why this is happening, but I'm using
SUMIF formulae that references external links (source data is in external
file). The correct value is retrieved when the source file is open, however,
when the workbook is closed, I get a #VALUE error. Since I have heaps of
formulae in this workbook (and a couple of others) relying on this external
source file, I want to make sure that I can view the correct values when the
source file is closed. Also - if I send the report to team members, I want
them to be able to view the data without having to open the source file.
Any ideas on how to get this link to work when the source file(s) is closed?

Thanks!!