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