External file references must be open?

[DavidRennox]

When I reference an external worksheet in a formula, it seems that the external file must be open for the formula to work?

[Dave Peterson]

For some functions like =countif(), =sumif(), =indirect(), yep. The sending
file has to be open.

For other functions, nope.

DavidRennox wrote:
>
> When I reference an external worksheet in a formula, it seems that the
> external file must be open for the formula to work?
>
> --
> DavidRennox
> ------------------------------------------------------------------------
> DavidRennox's Profile: http://www.excelforum.com/member.php...o&userid=36854
> View this thread: http://www.excelforum.com/showthread...hreadid=568055

--

Dave Peterson