Errrm... where & how do i use the Add-in?

"Jacob Skaria" wrote:

Unless you use an Add-In; these formulas will work only if all external data
sources are open.

If this post helps click Yes
---------------
Jacob Skaria


"jaysan3" wrote:

I have a formula linking to another worksheet but it does not show the result
unless I open that worksheet too. Any ideas? Please correct me if my formula
or excel settings is wrong.

=COUNTIFS('d:\[Outgoing List
2009.xlsm]Outgoing'!$J$2:$J$10000,$A33,'d:\[Outgoing List
2009.xlsm]Outgoing'!$T$2:$T$10000,"01/01/09")

When I tried a simple formula, it works fine.
=d:\[Outgoing List 2009.xlsm]Report'!$B3