Hello,

I've come upon a dilemma in linking several workbooks together into a summary worksheet. They are referred to nested inside of an =countif formula.

I have 4 source workbooks (2004, 2005, 2006, 2007) which are being summarized into a summary workbook (summary). The problem is, whenever I open Summary, it attempts to autoupdate the values, and cannot do so unless the four source workbooks are already open, which a) is halfway redundant, and b) is a problem as some of the source data isn't to be seen by other people.

Is there a way around this problem? The formula I have is listed below.

Thanks for all your help,
P

=COUNTIF('\\company share\Databases\[2004.xls]Plano'!$AC$3:$AS$174,A10)+COUNTIF('\\company share\Databases\[2004.xls]Lens'!$AC$3:$AS$6,A10)+COUNTIF('\\company share\Databases\[2005.xls]Plano'!$AC$3:$AS$174,A10)+COUNTIF('\\company share\Databases\[2005.xls]Lens'!$AC$3:$AS$6,A10)+COUNTIF('\\company share\Databases\[2006.xls]Plano'!$AC$3:$AS$174,A10)+COUNTIF('\\company share\Databases\[2006.xls]Lens'!$AC$3:$AS$6,A10)+COUNTIF('\\company share\Databases\[2007.xls]Plano'!$AC$3:$AS$174,A10)+COUNTIF('\\company share\Databases\[2007.xls]Lens'!$AC$3:$AS$6,A10)