Hi,
I'm gathering information to a seperate Total workbook from several
different woorksbooks (weekly files which has always the same format). On
Total woorkbook I'm having formula like =SUMIF([w28_08.xls]report!$G:$G,
"July", [w28_08.xls]report!$I:$I) and it works fine when the W28_08 document
is open, but when it closed and and I update the information when opening the
destination file(Total) it just gives me #Value! to all the cells which have
the formula.
Any kind of help would be appricated.

--
Thanks in advance, Virpi

If the external source is not going to be open, you must include the path to
the file location:

=SUM('C:\Reports\[Budget.xlsx]Annual'!C10:C25)

If on a network drive, use the UNC path instead of a named drive.

=SUM('\\servername\sharename\folders(s)\[Budget.xlsx]Annual'!C10:C25)

"Virpi H" wrote:

Hi,
I'm gathering information to a seperate Total workbook from several
different woorksbooks (weekly files which has always the same format). On
Total woorkbook I'm having formula like =SUMIF([w28_08.xls]report!$G:$G,
"July", [w28_08.xls]report!$I:$I) and it works fine when the W28_08 document
is open, but when it closed and and I update the information when opening the
destination file(Total) it just gives me #Value! to all the cells which have
the formula.
Any kind of help would be appricated.

--
Thanks in advance, Virpi

On Jul 22, 9:41 am, TWhizTom
wrote:
If the external source is not going to be open, you must include the path to
the file location:

Actually, I don't think that matters. Excel knows the path already and
will show it if the source workbook is NOT open. It does not show the
full path if the source is open.

Some formulas simply do not work when the source workbook is closed. A
workaround is to have a macro that opens the source, calculates, then
closes it. Assuming you really don't want to have the source open at
all.