Hello Excel Mavens,
I have worksheet linked to another workbook.
I have an equation that pulls data from that linked workbook.
When I open the workbook, the data does not get updated and I get the #VALUE
error. If I open the linked workbook the data updates.
Other linked equations (to the same workbook) refresh perfectly.

The equation is:=COUNTIF('S:\[Nov 05 Recap.xls]Sheet1'!$E$7:$G$21,O4)
This is Excel 2003 Pro (both workbooks)

Any ideas would be appreciated.

Brian