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")