There are some functions that don't work with closed workbooks:

=indirect(), =sumif(), =countif()

are a few

shakey1181 wrote:
>
> I need the sheet to reference another file and update accordingly. I have
> entered the destination of the file required and cells to be referenced etc.
> This works fine if both files are open at the same time.
>
> However, when I open the main file, it asks me if I want to update, and I
> have to choose yes as it is referencing daily reports over a month, so I need
> it to update automatically. When I choose yes, the fields error and don't
> populate correctly, even though the destination in the formula is still
> correct. What am I doing wrong?
>
> Thanks in advance

--

Dave Peterson