External file references must be open?

D

DavidRennox

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

Dave Peterson

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

For other functions, nope.
 
Top