I guess what is happening is that, when the workbook with the formulas and
the workbook being reference are open together, the formula is

=COUNTIF('[01-08-07TacomaDispatch.xls]Tacoma'!$C:$C,E5)

but when just the formula sheet is open, the formula turns into

=COUNTIF('O:\Tacoma Dispatch\2007 Dispatch\Tacoma 2007\
[01-08-07TacomaDispatch.xls]Tacoma'!$C:$C,E5)

"Arlen" wrote:

I have a workbook with a formulas referencing 5 other workbooks. Whenever I
sort the results, or close and open it, all results turn into #Value. The
numbers come back when I reopen the workbook being referenced, but really,
there must be something we can do?

Here's one of those formulae:
=COUNTIF('O:\Tacoma Dispatch\2007 Dispatch\Tacoma
2007\[01-08-07TacomaDispatch.xls]Tacoma'!$C:$C,E5), and Error Checking
underlines everything, then just E5...so there.

Also, is there a way to bypass the Update Links screen if the file hasn't
been moved or renamed?

I thank you for your time.

Arlen