Linked Workbooks returns #VALUE Excel 2007

[rrcrossman]

I have 8 workbooks linked to a master.
If the workbooks are ALL open, it works fine, but once I close them I get #VALUE in all fields. I don't remember having this problem until the last 6 months or so. What can I do to resolve this?
I read somewhere if you are using COUNTIFS that may be the problem ???

HELP !!!!

[FDibbins]

what formula are you using to get the data from the source files?

[rrcrossman]

=COUNTIF('[IMPORTS EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)+COUNTIF('[TOYOTA EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)+COUNTIF('[CHEVY EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)+COUNTIF('[CHRYSLER EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)+COUNTIF('[KIA EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)+COUNTIF('[VOLVO EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)

When all are closed:

=COUNTIF('C:\Users\Linda\Documents\Byers\Survey\[IMPORTS EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)+COUNTIF('C:\Users\Linda\Documents\Byers\Survey\[TOYOTA EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)+COUNTIF('C:\Users\Linda\Documents\Byers\Survey\[CHEVY EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)+COUNTIF('C:\Users\Linda\Documents\Byers\Survey\[CHRYSLER EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)+COUNTIF('C:\Users\Linda\Documents\Byers\Survey\[KIA EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)+COUNTIF('C:\Users\Linda\Documents\Byers\Survey\[VOLVO EXIT SURVEY NEW.xlsx]Sheet1'!$L$3:$L$200,$A4)

[popipipo]

Countif formulas don't work with closed workbooks, it never has.

[FDibbins]

popip is correct, perhaps you could perform the count in the source workbook and then reference the answer from your master? It should be a simple matter to reference the criteria from the master to the source and then use that reference in the source for the countif()