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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

External reference for Offset formula 2
Unknown repair 1
OFFSET and external workbook references 3
=Sum(if( 3
Range Names convert to Cell References 10
External Workbook References and Functions 1
variable substitution in a formula linking to external workbook 2
FInding external link 1

Top