When linking a spreadsheet to another workbook using a countif formula, the spreadsheet requires the linked workbook to be open for the formula to work. If the linked workbook is closed, VALUE is returned in the formula.

Not sure if this a quirk to 2007 or otherwise. Has anybody else come up against this and more importantly, found a way around it?

Cheers

Chris