hi
you would have to have the entire file path in the formula in order for the
formula to work while the source workbook is closed. here is an example of
one i use.

='C:\Documents and Settings\FSt1\My Documents\XL\[BCPlan.xls]Expences'!$G$2

note the apostrophes.
the formula you are using now can find the source workbook while it's in
memory but once closed, you need the file path also.

Regards
FSt1

"STEDIX" wrote:

I have two separate workbooks on different network drives. One is a SHARED
workbook and one is not. What I am doing is using a COUNTIF formual to bring
counts from the Shared workbook to the other workbook. I can get an accurate
value. However, when I close the source workbook, I get the #NAME! Error in
the field with the formula. When I reopen the source workbook and update the
other workbook the #NAME! error goes away and the correct value appears.

Any help would be apppreceiated. Here is the formula:

=COUNTIF('[Safety Meeting Resource Library for Branch and Driver
Meetings.xls]Fargo'!$B$10:$B$134,"April-09")