External file references must be open?
 

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

External file references must be open?
 

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