External file references must be open?

  • Thread starter Thread starter DavidRennox
  • Start date Start date
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
 
For some functions like =countif(), =sumif(), =indirect(), yep. The sending
file has to be open.

For other functions, nope.
 
You must log in or register to reply here.

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
How to subtract a number from a Mergefield? 0
Excel #Value! Error on external link, when source file closed 3
OFFSET and external workbook references 3
Invalid external reference message 2
=Sum(if( 3
variable substitution in a formula linking to external workbook 2

Back
Top